Filter Measure

Comments

18 comments

  • Avatar
    Michael Becker

    Hi Alon,

    quick question: I need to duplicate value column and filters on the ElastiCube level, right? You can't add the same field twice to filtering pane and you can't use the same column for aggregation on the widget? Thanks for clearing that!

    Michał

  • Avatar
    Alon Ahronberg

    Hi Michal,

    Correct for the filters part, since you can't use the same filter in the dashboard, you  need to duplicate it.

    You can however use the same measure few times, so no need to duplicate this value (you might have difficulties to give it a different name, to overcome it you can multiply by 1 and then rename it in different names)

     

    Hopes that helps

    Alon

  • Avatar
    Michael Becker

    Hi Alon,

    I can't make this work. Should the widget parameter also be changed? I've done as per instructions but it not acting as expected. Thanks in advance for any hints.

    Michał

  • Avatar
    Alon Ahronberg

    Hi Michal,

     

    Is the attached example working for you (the dashboard is connected to the sample E commerce cube) ?

    Please make sure the files extracted correctly into C:\Program Files\Sisense\PrismWeb\plugins\filterMeasure (there is no addtional "filterMeasure"  folder).

     

     

  • Avatar
    Michael Becker

    Hi Alon,

    no it is not working. initial state of that dashboard is ok, but when I change anything it stops working.

  • Avatar
    Alon Ahronberg

    Hi Michal,

     

    Is one of the measures saved to the "starred" formulas ? if so, that can cuase the widget to not function. that's a know issues that should be addressed in this pluding

  • Avatar
    Michael Becker

    Hi Alon,

    found it; for whatever reason an unwanted ')' appeared in my code and broke it. By the way could you change the description in this post to edit widget script not dashboard script, it is confusing. Thanks a lot!

    Michał

  • Avatar
    Alon Ahronberg

    Great ! Thanks for the update,

    Changed :)

  • Avatar
    Shay

    Hi,

    Is there a way to add a comparison between the two measures? for example i now have Revenue Date1 and revenue date 2 and i want to have a third measure which will indicate if Revenue Date1 is bigger then Revenue Date2 the new measure should also have conditional formatting. alternatively, i want to have conditional formatting on Revenue Date1 if he is bigger then Revenue Date2

     

    Thanks

  • Avatar
    Michael Becker

    Hi,

    a quick note, when using this with Line Chart, in JS you need to specify a simple measure, as soon as you even multiply it by 1 it will stop working.

  • Avatar
    Alon Ahronberg

    Hi Michal,

    Thanks for  bringing this to our attention, R&D is investigating the issue.

    Will update once a fix will be available.

     

    Regards,

    Alon

  • Avatar
    Malinda Jepsen

    I'm trying to use this to have a column not be affected by a filter.  The column is from another fact table, and whenever I bring a filter from the first fact table, the data from the second fact table will not display.  That's why I want to ignore the filter on that column (not sure why this is happening since that filter doesn't impact the second fact table at all).

  • Avatar
    Michael Becker

    Hi Malinda,

    It seems liek you're trying to dispaly two columns from two different fact tables that are not connected in ElastiCube or data within those two tables does not match at all. I suggest using this plugin instead, it maybe better for your needs - https://support.sisense.com/entries/66289224-Filtered-Measure-Plugin-Parameters-

  • Avatar
    Malinda Jepsen

    Thanks Michal.

    That doesn't seem to do what I need either.  I just want to turn off the filter for a column, it's a little different than having two different filters apply to two different columns.  I wasn't able to get the "@" syntax to work for a dashboard filter (not a widget filter).

    Malinda

  • Avatar
    BI Reporting

    Hi,

    We deployed this plugin on our server and it conflicted with IE11. None of our users were able to access dashboards after giving credentials on login screen. Screen just went blank.

    However it does not conflict with GoogleChrome or Firefox.

    We are on Sisense 6.5.2.11007. Is there a updated plugin or latest Sisense versions? or its deprecated? 

  • Avatar
    Jonathan Pires

    Hello,

     

    This issue has been addressed and the resolution will come out in our next 6.6.1 hotfix!

  • Avatar
    Ayanda Dube

    Good Day, 

    Does this plugin work on 6.7?

    Thanks,

    Ayanda

  • Avatar
    Jim Belden

    Does this plugin work on 7.0?

    Thanks,

    Jim

Please sign in to leave a comment.