Forum Discussion

AlycnBjergo-Jus's avatar
AlycnBjergo-Jus
Qrew Member
5 years ago

Slicer within Widget Graph

Is there a way to put in a slicer within a graph widget?

------------------------------
Alycn Bjergo-Justen
------------------------------
  • What is a slicer?  Do you mean Dynamic Filters.  If so, yes, you can use Dynamic filters on a chart type report.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • AlycnBjergo-Jus's avatar
      AlycnBjergo-Jus
      Qrew Member
      So if I am on a dashboard and looking at a Total spend by Month graph widget, I want the user to be able to filter within the dashboard widget by State for example.  If they select a certain state, the graph will change.
      Is that in a dynamic filter for a graph widget?

      ------------------------------
      Alycn Bjergo-Justen
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        If you run the regular report, then you will be able to use the Dynamic filter.  But Dashboard reports do not currenty suport the use of Dynamic Filters.

        If you want though you can try the work-a round.  You can take the URL you see when you run the report and copy it to your clip board.

        The add a Dashboard widget as a "webpage" and paste in that URL, but suffix it with with &ifv=1   so for example https://mycompany.quickbase.com/db/bg9ep69j4?a=q&qid=10&ifv=1

        If you do that, I suggest that you set the chart to not allow drill down as the user experience will get weird when they drill down.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------