Multi-Value Gauge Showing 0 Change
I'm working with a dataset that is organized by date and account name and for each date and account name, there is a total number of subscribers. I'm trying to show the total number of subscribers over all accounts for yesterday and the value change from the day before. The value for yesterday is there but the value change is just showing 0. Here are my settings:
Best Answer
-
The issue is your date range filter is set to Yesterday. That means it will only return 1 day and likely 1 row if you have 1 row per day. If you want to compare yesterday to the day before yesterday, set your date range filter to Last 3 Days. Then sort by date descending. This will make the day before yesterday as the last value and yesterday as the penultimate value. You can then configure the gauge to look at those values and you should see a change.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
Also, I have ensured that there is, in fact, a value change between yesterday and the day before yesterday
0 -
The issue is your date range filter is set to Yesterday. That means it will only return 1 day and likely 1 row if you have 1 row per day. If you want to compare yesterday to the day before yesterday, set your date range filter to Last 3 Days. Then sort by date descending. This will make the day before yesterday as the last value and yesterday as the penultimate value. You can then configure the gauge to look at those values and you should see a change.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@MarkSnodgrass I made this change and my value changed from 790 to 792 with a value change of +2. 790 was the accurate count for yesterday's subscribers. So, I'm not sure where I'm going wrong now.
0 -
A couple things to try. Add ReportDate into the Optional Group By. Also, try changing Data from Last and X Periods Ago to Last 2 Values.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Looks like the ReportDate just needed to be sorted by Ascending, not Descending.
1 -
Ah that makes some sense if you are using the x Periods Ago rather than the Last 2 Values.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Thank you for your help!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 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