Build card to Display Status of Dataset
I'd like to build a card to show me the status of a dataset. I'd like to have it displayed say first thing on a subpage to show perhaps that the dataset for that subpage is say updated within last 24 hours (Green), within month (yellow) otherwise Red
Something like that?
ANy ideas as to how i could do this?
Comments
-
I think i may have found a solution to my own problem. I created a ETL 'Dashboard Status' that takes the several datasets i use on the subpage as inputs, then adds constant column Last updated, type Date and fills with Current Date
So i assume since all the datasets/etl are set to update based on inputs, only when my source sends update will the 'Dashboard Status' ETL be updated?
Then i created a card that has a new Value 'Group' which says
(case
when `Last Updated` = CURDATE() then 2
when `Last Updated` < CURDATE()-1 then 1
else
0
end)Created a Face Guage that says show green if min, max is 2
Yellow if min max is 1
otherwise red
So I think this will work in that if the Dashboard Status ETL is not updated, which means the Datasets and ETL that it is based on does not update daily, it will show Yellow if it is one day old and red if more?
Does anyone see any issues with this logic?
0 -
So, this does not work. How can i somehow get the date into the ETL or Beastmode of when the dataset was last updated?
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive