Filtered Measure Plugin (Parameters)

Comments

25 comments

  • Avatar
    Odir

    Hi, the link to download the plugin is broken, is there any other way to download it ?

    0
    Comment actions Permalink
  • Avatar
    Itay Seroussi

    Thank you Odir, the broken link has been updated.

    Please note that the plugin has been updated, the post has been updated accordingly.

    With the new plugin, related filters should remain active and affect widget.

    If you wish to replace the previous FilteredMeasure plugin with the new one, please make sure to remove the old plugin folder. 

    1
    Comment actions Permalink
  • Avatar
    Konstantinos

    Hi there. This Plugin doesn't work when the filter is dependent. Is there any solution for that?

    0
    Comment actions Permalink
  • Avatar
    Hila Kantor

    Hi Konstantinos,

    Please try to apply it on the father-filter. It should work. 

    0
    Comment actions Permalink
  • Avatar
    Konstantinos

    Hi Hila,

    I have applied it to the father-filter but it is still doesn't works

    0
    Comment actions Permalink
  • Avatar
    Hila Kantor

    Hi Konstantino,

    Can you please attach the ecdata and the dash file / send it to me? (hila.kantor@sisense.com)

    0
    Comment actions Permalink
  • Avatar
    Evan York

    This plugin seems broken in v6.5.  Has anyone got it working??

    0
    Comment actions Permalink
  • Avatar
    Omer

    Hi Evan, 

    The plugin is supposed to work on v6.5 .

    Could you please describe step-by-step how you tried to implement it?

    Thanks,

    Omer

    0
    Comment actions Permalink
  • Avatar
    Evan York

    Hi Omer,  I created a ticket for this issue (#36232).  Let me know if you can help. Thanks!

    0
    Comment actions Permalink
  • Avatar
    Ramon Lopez

    FYI - tested this plugin in 6.7 and it is working well.

     

    regardsm

    Ramon Lopez

    1
    Comment actions Permalink
  • Avatar
    Ayanda Dube (Edited )

    Hey Ramon,

    I have a situation in which I only want to have a one-dashboard-filter-for-all where I can filter by specific items in a field for one widget and filter by everything but those items in another widget. In essence, what I'm excluding in one widget is being included in another. Below is what I did:

    Step 1: Install Filtered Measure Plugin as instructed above and for a field called "Airline", duplicate it and have a field called "Airline1". Add both fields in the dashboard filter as instructed and name them "Controllable Airlines" and "Uncontrollable Airlines" . Since Controllable Airlines outnumber Uncontrollable Airlines it is easiest to exclude the uncontrollables. 


    Step 2: In one of my column chart widgets I apply the magic of the filtered measure plugin on one of the values (USD Controllable Fulfillment)

    Step 3: Use the "Uncontrollable Airlines" filter on a couple of widgets.

     In the grand scheme of things this is fine. But it is not fluid. The viewer of this dashboard has to deselect some items in one filter and select the exact same items in another filter.

    So my question is is there a way (perhaps some JS) in which I can keep only the "Controllable Airlines" filter to apply the filtered measure in that first widget and simultaneously in the other widget by inversely selecting everything but what's selected in the filter? 

    I hope this question makes sense.

    Thanks,

    Ayanda

    0
    Comment actions Permalink
  • Avatar
    Evan York

    Hi Ayanda, since they're exclusive wouldn't the sum of controllable + uncontrollable = total?  In that case maybe try something like this for the relevant uncontrollable metrics:

    [VALC USA Fulfillment]-([VALC USA Fulfillment],[@Controllable Airlines])

    Only 1 filter (controllable) needed!

    0
    Comment actions Permalink
  • Avatar
    Ayanda Dube

    Thanks Evan,

    I initially tried to use that logic but your solution helped me reach the answer I was looking for. Some probability math was also required. So the solution was:

    ([VALC USA Fulfillment]-([a weight for uncontrollable airlines]*[uncontrollable fulfillment])/[a weight for controllable fulfillment]

    Regards,

    Ayanda

    1
    Comment actions Permalink
  • Avatar
    Oxana Noa Umansky

    Thanks Ayanda!

    0
    Comment actions Permalink
  • Avatar
    Alexandros Antoniou

    Does this plugin still work in version 6.7.1.15?

    I am experiencing many issues...

    1. I noticed that you need to use the "@" to ignore a filter (not to apply).

    2. I cannot get some filters to work.

    0
    Comment actions Permalink
  • Avatar
    Alexandros Antoniou

    In continuation to my previous question.. 
    3. Can I add two filters and formula (i.e. two @...)
    4. Is it ok to have dashboards filters that are applied normally (like salesdate filter)

    0
    Comment actions Permalink
  • Avatar
    Ayanda Dube

    Good day,

    Does the plugin work on v7?

     

    0
    Comment actions Permalink
  • Avatar
    Evan York

    Ayanda - Existing formulas using this plug-in do work fine in v7, but there is currently a v7 bug renaming fields in formulas that makes it impossible to create any new formulas or edit any existing formulas that leverage this plug-in.

    I suggest to avoid it with v7 until SiSense confirms a fix to renaming fields in formulas.

    0
    Comment actions Permalink
  • Avatar
    Ayanda Dube

    Thank you Evan,

    This explains why I was unable to create new formulas. Much appreciated, my friend.

    0
    Comment actions Permalink
  • Avatar
    Sam Ovenshine

    As Evan mentions, there is an issue in Sisense 7.0 where the formula cannot be renamed through the web UI (Step 6). This issue will be resolved with Sisense 7.1.

    As a workaround in the meantime, export the .dash file and open it in a text editor. The dash file is a JSON structure that determines the objects and properties of your dashboard.

    Navigate to widgets[i].metadata.panels[i].items[i].jaql.context[i] - this is within a section that defines the JAQL for a widget measure. Navigate to the "title" key. Prepend @ to the existing value. For example, to complete Step 6 above, navigate to:

    "title": "Year1"

    Change it to:

    "title": "@Year1"

    After making the change, save the .dash file and reimport it (and select Overwrite as the method).

    Extract from a sample .dash file

    0
    Comment actions Permalink
  • Avatar
    Oxana Noa Umansky

    Hi all,

    We've updated the plugin to support version 7.0.1, including:

    1. Auto Sync of all filters for a specific measure using the measure menu button and clicking the option "Sync Measure with filters" - automatically adds all filters to the measure and adds a prefix of '@'
    2. Auto Sync of all filters with all measures in the widget using the widget menu button (editor page) and clicking the option "Sync dashboard filters with measures" - automatically adds all filters to all measures and adds a prefix of '@'
    3. Support in Prev Year/s, Just rename the field (in the formula) to '@.PREV.[filter name]' or to '@.PREV.[number].[filter name]' to get results of the previous [number] of years
    4. Support for cascading filters

    Thanks,

    Oxana

    0
    Comment actions Permalink
  • Avatar
    Ayanda Dube (Edited )

    Thank you Oxana!

    1
    Comment actions Permalink
  • Avatar
    Todd Nash

    I've attempted to utilize this widget but experiencing some issues.  In my case, I have created a duplicate field for Country in an effort to display a comparison between Domestic (US) and International.  Unfortunately, when the filter selections are made (County: United States, Country1: Not United States) the filters cancel each other and end up displaying "No Results".  Note: I am on Version 7.1.0.12003

    2
    Comment actions Permalink
  • Avatar
    Jessica Orlando

    I am experiencing the same issue as Todd. The filters appear to be cancelling each other out and I am getting no results back. I am on 7.1.1.10089

    0
    Comment actions Permalink
  • Avatar
    Sebastian Cabbe

    Hi, 

    Will there be an update for this plugin for Sisense version 7.2? 

    It is currently not working and I have a lot of dashboards with comparisons that depend on this.

     

    0
    Comment actions Permalink

Please sign in to leave a comment.