Slicer within Widget Graph
Is there a way to put in a slicer within a graph widget? ------------------------------ Alycn Bjergo-Justen ------------------------------
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWhat 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
------------------------------
Is that in a dynamic filter for a graph widget?
------------------------------
Alycn Bjergo-Justen
------------------------------
- MarkShnier__YouIf 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
------------------------------- I agree with Mark.
In addition, if you need the drilldown, you can have the users click the scroll button (middle mouse button) or hold down Ctrl and then mouse click. This will open the drilldown in a new tab and leave the webpage widget as is. Or they can right click and select open in new window (not sure about a hotkey for the new window option).
I have one app dashboard with code pages embedded as webpage widgets. Each code page contains several reports and I use this as a workaround to the limit on the number of reports allowed on a single dashboard. If I drilldown into one of the reports in the widget without opening in a new tab or new window, a Quick Base window opens and fills the entire widget and there is no back button. This is not a big deal since at the moment I am the only one using it, but if there were many people using it I would probably opt for a different solution.
------------------------------
Adam Keever
------------------------------
