How to select most recent data for bar chart
Greetings - I recently posted asking about defaulting to the most recent data for a single value chart and got a great solution; now, I'm struggling with the same issue with a stacked bar chart where I don't have the option to use the value from the last row of data. My data is usually updated around noon; until then, I'd like the chart to display yesterday's values. Here's what my chart looks like (I changed to yesterday so that there would be data, but have had it set to today). Thanks in advance for your help.
Comments
-
You could try a BeastMode around the lines of:
case when `Date` = CURRENT_DATE() then CURRENT_DATE() ELSE SUBDATE(CURRENT_DATE(), interval 1 day) end
and use that as yourY-axis
2 -
Thank you!
1 -
Hi @Cartergan -- Thought your suggested beast mode was the solution, but it did not work. Today's data is not yet available and the chart is showing, "no data in filtered range". Any thoughts? Thanks.
I used:
case when `DATE` = CURRENT_DATE() then CURRENT_DATE() ELSE SUBDATE(CURRENT_DATE(), interval 1 day) end
@Cartergan wrote:You could try a BeastMode around the lines of:
case when `Date` = CURRENT_DATE() then CURRENT_DATE() ELSE SUBDATE(CURRENT_DATE(), interval 1 day) end
and use that as yourY-axis
0 -
@LLucinski You may need to change your date range to All Time.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive