Formulas as Filters - Dashboard Level

Comments

7 comments

  • Avatar
    Ravid Paldi

    I'm not sure what you mean but you can use filters within formulas in many different ways. 

    The simplest way is to the following syntax: 

    (FIELD1 , FIELD_TO_FILTER_UPON) 

     

    Elaborate more on what you need and I'll be able to help more

    0
    Comment actions Permalink
  • Avatar
    Matheus Magalhaes (Edited )

    Let's say I have a pivot table like this:

    Note: Qnt Difference is a formula created in the widget.

    I create a widget filter for the Qnt Difference Formula, which filters out the rows that have Qnt Difference = 0.

    However, sometimes users wants to see all the rows (including when Qnt Difference = 0). The issue is that the user has to be a designer to access the widget filter, and I do not want to give them designer license.

    Is there any way I can place the widget filter where the dashboard filters are located? This would allow any user, independent of user access, to filter this table on Qnt Difference.

     

    0
    Comment actions Permalink
  • Avatar
    Ravid Paldi

    I see. If I understand correctly, you are looking to move the widget filter(accessible only to designers and above) to be a dashboard filter (accessible to viewers) 

     

    Option 1: You can move the widget filter to be a dashboard filter if it doesn't relate to anything else in the dashboard.

    Option 2: Hack it within the cube by generating a flag or something that will be defined as a dashboard filter but will impact only on that specific widget. 

    The second option requires some work. Feel free t reach out if you want some  help with this 

    ravid@paldi.solutions 

     

     

    0
    Comment actions Permalink
  • Avatar
    Matheus Magalhaes

    Are you sure option 1 is possible? The Qnt Difference is a formula created within the widget. There doesn't seem to have a way of moving the widget filter to the dashboard filter.

    Option 2: I tried implementing flags but it is a very complicated data model and I still haven't figured a way of implementing them.

    0
    Comment actions Permalink
  • Avatar
    Ravid Paldi

    You are correct. I forgot that you were talking about filtering a calculated field. 

    You can most certainly implement the flags approach but it might require you to limit other segmentation possibilities you have in the dashboard as it means that you'll need to pre-calculate the formula in the cube in order to flag it. 

    If that's not an issue, feel free to send me the .ecube file and some explanations and I'll try to guide you on what to do. 

     

    If it is an issue, then you can always turn to some custom  JS code. It should be too complicated to develop, 2-3 days of work I believe. I'm not sure it worth the work but you know better then I do (: 

    0
    Comment actions Permalink
  • Avatar
    Thiyagarajan Parameswaran (Edited )

    I am also having same scenario as I need to apply the filter against the calculated field at dashboard level. The dashboard is out off pivot widjet.

    Did you sort out the problem? Please share the information that would be very helpful.

    0
    Comment actions Permalink
  • Avatar
    Ravid Paldi

    Hi Guys,

     

    Looking back at my answer, we can easily use custom BloX action so you could have a button that you can place next/above your that can modify that filter. We can develop it for you if you don't have the know-how. 

    Feel free to reach out if you have any questions (: 

    ravid@paldi.solutions

    Paldi Solutions

     

    0
    Comment actions Permalink

Please sign in to leave a comment.