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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 195 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 175 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive