Group By Filter for Dashboards
Hi Folks,
Is there a way to add a 'Weekly' 'Monthly', or 'Quarterly' filter to a dashboard that would aggregate best modes accordingly (when written dynamically) within charts by those groups against a date field?
The equivalent of the graph by feature in the analyzer:
I want someone to be able to select weekly and see an aggregation of a count by each week.
Kind regards,
Best Answer
-
@NateBI Yes, you can use the "Choose Date" drop down on the top right corner of the dashboard to change the date range and groupings. As long as your cards are grouped by a date dimension and the "Hide Date Range" box is unchecked in analyzer, the "Graph by" setting will apply to those cards.
2
Answers
-
@NateBI Yes, you can use the "Choose Date" drop down on the top right corner of the dashboard to change the date range and groupings. As long as your cards are grouped by a date dimension and the "Hide Date Range" box is unchecked in analyzer, the "Graph by" setting will apply to those cards.
2 -
@MichelleH Sweet - any chance this can be linked to a filter visual instead?
0 -
You can change the dates based on presets… not sure if you can change the graph by options with a filter card though. Maybe a feature request?
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
@NateBI You would likely need to set up a variable control for this and replace the date dimension each card with this beast mode:
case when `Date Grouping (Var)` = 'Week' then concat(date_format(`Date`,'%m/%d/%y')) when `Date Grouping (Var)` = 'Month' then concat(date_format(`Date`,'%M %Y')) … end
3 -
@MichelleH very interesting thanks!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive