Period over period gauge
Hi, I have crated a dashboard with a period over period gauge.
When I set the date range to "This year" which then looks from Jan - Aug as those are the only months this year with data I have noticed the previous period say 1 year ago is looking at the whole year. This obviously gives a silly variance.
Please tell me there is a way so it just matches on the data available for this year. The is vital to us as users just want to look at performance year to date,
Thanks
Best Answer
-
Use Year To Date as the option instead. Alternatively you can reformat your data and use a custom date dimension offset to better handle period over period analysis. I’ve done a write up on this here: https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Use Year To Date as the option instead. Alternatively you can reformat your data and use a custom date dimension offset to better handle period over period analysis. I’ve done a write up on this here: https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@GrantSmith perfect thank you. Not sure how I missed that option. 😀
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 694 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive