Dataset Alerts without Data Change

Hello,
Dataset alerts are triggered if a row is added, updated, or deleted. However, I'm looking to get alerts based on the data, even if the data hasn't changed. Here is the use case:
- All active projects are updated in a Domo dataset with a "Due Date" field
- Data import is set as "replace" instead of "append" even if there are no changes to any of the fields (I'm not sure if Domo considers this as a row added or no change if all the fields are the same)
- I want to trigger an alert if the "Due Date" is in the past.
In this case, the "Due Date" or any other data field hasn't changed, but the comparison date has increased. Is there a way to set up such an alert using Domo?
Answers
-
Hi @gsharma since you need some additional logic to look for rows where "Due Date" is in the past, I suggest setting an alert off of a card rather than the dataset. Use this beast mode to count the number of rows where the Due Date is in the past:
sum(case when `Due Date` >= CURRENT_DATE() then 1 else 0 end)
Add this beast mode as the summary number on your card and configure the alert to notify you daily if the summary number is greater than zero.
0 -
@MichelleH Thanks, that's helpful. However, after adding the new beast mode to the card's Summary, I see this message in the card:
"Failed to load alert configuration.
No alertable metrics found on this card. Please add a Summary Number or change chart types and try again."
Beast Mode count is showing the correct number though. Also, I'm using "Percent Complete Gant" chart.
0 -
Here you go!
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 113 SQL DataFlows
- 650 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 792 Beast Mode
- 78 App Studio
- 44 Variables
- 754 Automate
- 187 Apps
- 479 APIs & Domo Developer
- 71 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 407 Distribute
- 118 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive