Single value Card - most recent data
I have a single value card that produces the number of hospitalizations today. My dataset is updated everyday at around 3 p.m. I have the date range set to today. I know there must be a way, beast mode or transform, to specify the value from yesterday if today's data is showing zero. FYI, the actual value will only be zero when the data has not been updated.
I've searched the knowledge base and Dojo without finding anything that addresses this.
Very novice beast mode user; no programming backround.
Can anyone help?
Thanks!
Best Answer
-
I think you can accomplish this by making use of the various chart properties, sorting, and filtering capabilities and not have to worry about a beast mode.
Try this:
1. Set your Date Range filter back to all time
2. Drag your date field into the Sorting section and sort by ASC and make sure it is set to No Aggregation.
3. In the Chart Properties - General, choose Last Row for Value.
4. Drag the column your hospitalizations column into the Filtering section and filter it to Greater Than 0.
This combination should keep things dynamic for you and always show you the latest non-zero value.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Answers
-
I think you can accomplish this by making use of the various chart properties, sorting, and filtering capabilities and not have to worry about a beast mode.
Try this:
1. Set your Date Range filter back to all time
2. Drag your date field into the Sorting section and sort by ASC and make sure it is set to No Aggregation.
3. In the Chart Properties - General, choose Last Row for Value.
4. Drag the column your hospitalizations column into the Filtering section and filter it to Greater Than 0.
This combination should keep things dynamic for you and always show you the latest non-zero value.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
Mark - Thank you so much! I couldn't see the forest throught the trees and this was so easy. Thanks again, Laurie
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 107 SQL DataFlows
- 648 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 775 Beast Mode
- 75 App Studio
- 43 Variables
- 734 Automate
- 186 Apps
- 471 APIs & Domo Developer
- 63 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 137 Manage
- 134 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive