How to build a card which show the latest-date data only?
Hello,
I have lots of datasets, which are updated by daily/weekly/bi-weekly. They dont have a specified update date.
I'd like to build cards based on them which show the "latest-date" data only, and should be updated automaticly when datasets updated.
I notice "date_range" in domo cards build don't have a non-specified latest_date field.
And if using a beastmode to be added as a filter, it will report error.
CASE
WHEN `aggregation_date` = max(`aggregation_date`) then 'Yes'
ELSE 'No'
END as latest_date
Do you have a workaround solution?
Thanks.
-Julien
Best Answer
-
What we've done before is add a last day, last week or last month indicator column and populated the column with an X for those records. Then in Domo, you just add a filter to the cards so it only shows where the Last Day/Week/Month column is set to X.
The donwside of doing it this way is that the time grain at the top becomes useless.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1
Answers
-
Not sure I understand the requirements so my comment might not be so helpful but have you looked at using the _Batch_Last_Run_ field that displays when your DataSet was last run/updated?
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**1 -
Thanks TravisSimpson.
I want my domo cards be automically updated with latest data only.
As you see attached pics, the "_Batch_Last_Run_ field" is an specified date. I must specify an exact date as the filter in the cards building. So in this way, the card won't be automically updated later.
If the "_Batch_Last_Run " is a boolean field, then it will be helpful in this case. I could set "_Batch_Last_Run " =true as the filter directly.
We have lots of similar usage on domo cards, please help. Thanks.
1 -
Does anyone have an answer to @happyzoom's and @julienj's questions?
0 -
What we've done before is add a last day, last week or last month indicator column and populated the column with an X for those records. Then in Domo, you just add a filter to the cards so it only shows where the Last Day/Week/Month column is set to X.
The donwside of doing it this way is that the time grain at the top becomes useless.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1 -
Thanks Godzilla and domo all. I'd like to have a try on this.
0 -
I actually found a solution for this using ETL instead of SQL. I did a Rank and Window function on the Batch ID field, where I ranked the ID by descending order so that the latest batch will also have a rank of 1. Then I did a filter in the ETL to only show rows with a rank of 1 (you can do this filter with Beast Mode instead if necessary).
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 728 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