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.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