Global date range filter in dashboard, have it compare to exactly a year ago in guage card type.
I have a dashboard that displays metrics from social media platforms, and I would like to apply global filters so the client can filter specific dates, but then also show what those values were exactly a year ago.
Example: Say the client wants to see total impressions for April 12-17, 2023. I would like the card to filter to show the value, but then also have the comparison (percent increase/decrease) draw from April 12-17, 2022.
Right now I am using a variable called "Timeframe" to allow the user to select the timeframe they would like to see, and I have custom beast modes for every card in the dashboard. In our specific use case, the client is requesting to be able to select the dates they want, and see the comparison for a year ago, so this isn't going to work. It would be great if the global filter on the dashboard had a way to automatically compare the current year date range to the prior year date range. Any ideas or workarounds I may be able to use here?
Best Answer
-
Hey @jakebutterfield
I recommend restructuring your data model so you can have multiple periods for each date (in your case this year and last year). I've done a write up on this in the past which might be helpful for you.
This way they can select whatever date range they want and see the selected. value and the value from last year.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
Hey @jakebutterfield
I recommend restructuring your data model so you can have multiple periods for each date (in your case this year and last year). I've done a write up on this in the past which might be helpful for you.
This way they can select whatever date range they want and see the selected. value and the value from last year.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
@GrantSmith Okay I've seen this answer from you before when I was just starting DOMO but now that I know more I gave it a try, and this is amazing! I work a lot with date comparisons and there is a lot you can do with this, Thanks Grant. Super easy to follow along with your steps and now I am able to use Period Type beast modes to get what I am looking for.
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive