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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive