Discussions

Expand all | Collapse all

Dynamic Dashboard with multiple Filters

  • 1.  Dynamic Dashboard with multiple Filters

    Posted 05-26-2017 18:34
    I want a dashboard with 7-8 reports and multiple filters. So by applying a filter, all reports change dynamically. 

    See Picture Attached.


  • 2.  RE: Dynamic Dashboard with multiple Filters

    Posted 05-26-2017 18:51
    I way to get close to this in a multi user environment is to have a table of Users in the app where the key field is the userid. That record will need to have all the filters which you would need.  You would probably have to have multi select field types uses to allow selecting multiple choices for one filter.  

    Then in each details table where the data is, you will create a field called [Current user] with a formula of User().  That will be used to make a Relationship to the Users table, where you can then look up those values down to the details tables. 

    Then they will be available for you to contrive specials version of the reports to use as dashboard reports.  So while these would not be Global Dynamic filters, the user could select their record  and specify Global Dashboard filters.

    Typically, you include a report on the Dashboard of users where the user is the current user, so it easy for the user to locate their user record. 


  • 3.  RE: Dynamic Dashboard with multiple Filters

    Posted 05-26-2017 19:35
    This is helpful when I have only one filter. What I have 3 section of filters and I want to apply from all 3 sections.


  • 4.  RE: Dynamic Dashboard with multiple Filters

    Posted 05-26-2017 19:38
    You can have as many fields as you like on the user record and look those up to your details table. The trick is really to come up with the correct set of filters which will allow you to select no filters for a particular field or else apply filters if some were selected.

    If you can get it working for one filter, then you should be able to get it working for more filters


  • 5.  RE: Dynamic Dashboard with multiple Filters

    Posted 05-26-2017 19:42
    I got your point. But now think I have 15 filter which means I have to create 15 fields. 
    Is it a best practice.


  • 6.  RE: Dynamic Dashboard with multiple Filters

    Posted 05-26-2017 19:44
    Are you saying that you have 15 different fields that you need to filter on?  yes, if so then you will need to bring down 15 lookup fields to each of the details tables.


  • 7.  RE: Dynamic Dashboard with multiple Filters

    Posted 05-26-2017 19:55
    Is it a best practice to do. Any other alternative.


  • 8.  RE: Dynamic Dashboard with multiple Filters

    Posted 05-26-2017 20:00
    Well, it is the only native solution as far as I know.  The concept was just demoed at the recent EMPOWER meetings and no one chimed in to say there was a better native solution.  If course, nI suppose that with scripting, anything is possible if you happen to be a coder. 

    The only other thought I have is there is a QuickBase feature called an Application variable, which is global across all tables.  But even if you made some kind of API buttons ot update those, regular users do not have Admin permission to update those variables. 


  • 9.  RE: Dynamic Dashboard with multiple Filters

    Posted 05-26-2017 20:13
    I can understand. I was about to meet you and want to talk you about this but unable to spot you in the empower. Yes, It is simply achieved by coding. I was part of the App-a-thon and did the same by using scripting languages.
    I will do more research and try to come up with a solution.

    Thanks


  • 10.  RE: Dynamic Dashboard with multiple Filters

    Posted 08-08-2018 12:23
    I'm running into a situation here where I've got the relationships and lookups created however how do I update the dashboard reports properly? I can add the new lookup field to the filter but what do I compare it to? The only options I have is where the lookup field is equal to / contains a value from another multi select field.

    Thanks!