Creating a dynamic custom filter

Answered

Comments

11 comments

  • Avatar
    Antwan Dandy

    Would it be possible to set Formulas as Dashboard filters?

     

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi Antwan,

    1. Yes it is possible, as long as the underlying tables are connected in ElastiCube

    2. I think you can use formulas as filters on widget level, but I'm not sure about the dashboard.

    Hope it helps.

    Regards,

    Michał

    0
    Comment actions Permalink
  • Avatar
    Malinda Jepsen

    The only way I've been able to accomplish this is to use a Tabber widget and have the tabs be the different measures.  I think of this more as a measure switcher than I do a filter switcher.  

    Michael, were you able to implement a formula for the filter? The only way I know how to do that is to have the filter come from the Elasticube.  Is it JavaScript you're using?  If so, please share some code/concepts.  Thanks!

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    @ Malinda - In general I do it following way (did it on couple occasions, but can't vouch for this being consistent):

    1. Create a custom formula on Value section within a widget.

    2. Click on filter button for that formula and that will add it as filter for that widget. Now you can set it up according to your liking.

    That should enable filtering on the formula, but as I mentioned above I can't vouch for that being consistent and working in each and every case. Hope it helps.

    Regards,

    Michał

    0
    Comment actions Permalink
  • Avatar
    Malinda Jepsen

    Thanks Michael!  

    I forgot about using custom formulas in the UI.  I've had issues with them when I was gong from dev to test to prod, so I stopped using them (or for example, starting with a new .ecube file to create the same cube).  I don't remember the specifics now.

    What I'm trying to do is let the user decide which measure they want to see. So I want them to be able to pick a filter (in the right hand nav or a custom filter) and then the widgets all display that measure instead of the one they were designed with.  I'm trying to figure out if there is some JavaScript where I can change the "source" of the measure at run time.  I could use a tabber and I could use two separate dashboards, but our users don't think like that.

    When I read Antwan's post, I was envisioning what I was trying to do, but you may be closer to what he's asking.  Antwan, can you clarify?

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi Malinda,

    You might be actually right that switching measures is what Antwan needs. @Antwan - can you clarify what is your business case exactly?

    @Malinda - instead of Tabber I would use this - https://support.sisense.com/hc/en-us/community/posts/221225468-The-Measure-Changer-Widget-Plugin - it keeps everything within a single widget and you can change secondary values on indicators as well

    0
    Comment actions Permalink
  • Avatar
    Malinda Jepsen

    Thanks Michael!  We already have the tabber widget and I don't like to have too many plugins.  When I glanced at this one, it was the same look and feel as the tabber and didn't look deeper. But in this case, it looks like it wouldn't have separate jaql for each widget which would improve performance. My real need is to change ALL of the measures on one page between two values.  I'm contemplating duplicating the dashboard and then having a link on the dashboard to switch to the other dashboard.  

    0
    Comment actions Permalink
  • Avatar
    Preethi M

    Hi all,

    How to create multiple filters under one filter. Example: When we take country as a lead source(parent filter) i will choose one country underneath it should display next filter which needs to filter state for the particular country selected after choosing state it should show city belong to that state. would it be possible to have all these in one filter.

    Any help or suggestions would be grateful

     

    Thanks in Advance,

    Preethi

    0
    Comment actions Permalink
  • Avatar
    Ido Darnell

    Hi Preethi M

    You can achieve exactly this by use of the native dependant filters

    Let me know if this resolves your need, 

    Feel free to reach out

    ido.darnell@qbeeq.pl

    qbeeq.pl

    0
    Comment actions Permalink
  • 0
    Comment actions Permalink
  • Avatar
    Preethi M

    Hi,

    Thanks for your comments. I need to do in Advanced filter plugin rather than using native dependent filter since few users are not aware of using right side panel which shows them the filters. Any suggestions would be grateful

     

    Thanks,

    Preethi

    0
    Comment actions Permalink

Please sign in to leave a comment.