Customized Alert (Recent drop data, SQL assert)
Best Answer
-
I would probably create a card just for this alert. Your summary number would be a beastmode. Something like this:
SUM(CASE WHEN `Date_Field`=CURDATE() THEN `users` else 0 end)
You could then schedule an alert on this card to contact you anytime the summary number was equal to 0.
You can even schedule the time that the alert will check if you want to wait until a specific time. (otherwise, I think that you would get an alert everyday around midnight)
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Answers
-
I have alerts built around age of datasets, an alert when total sales = 0, an alert around the last date that we received a service ticket...
What, specifically, are you wanting to be alerted on? I am not aware of an ability to add SQL like assertions to Domo datasets.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
Hey, thanks for the response!
Interesting, I believe that is something I am looking for.
I would like to be alerted on:
Every day, we have an expected SUM(users). Typically, this number is >0. However, when it it is 0, then that means data may have not came in from another dataset or etc.
Therefore, for, say today 5/7/19, I want to be alerted that a 0 value occured.
Note: I saw that alerts have total amount of values be = 0, but I want something like "recent day/today, if 0, then alert me)".Considerations: I thought about a % difference -, but if I did that, would it be 100% negative direction?
Looking forward to your response!
0 -
I would probably create a card just for this alert. Your summary number would be a beastmode. Something like this:
SUM(CASE WHEN `Date_Field`=CURDATE() THEN `users` else 0 end)
You could then schedule an alert on this card to contact you anytime the summary number was equal to 0.
You can even schedule the time that the alert will check if you want to wait until a specific time. (otherwise, I think that you would get an alert everyday around midnight)
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
You, you, are my Super(wo)man.
Good trick--thank you!
0
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 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
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive