Setting row level alerts for chnage of status
Hi!
I have build a table in Data for the finance related entries and have a columns names Rejected status which is rep[resented by a Y or a N. I want to set an alert on my table where if any of the lines gets rejected and turns to 'Y' then it should send out an email to a specific user email address on that chnage. I am not able to set that alert on my table. As soon as I try adding an alert option it gives me a message saying "No alertable metrics found on this card. Please add a Summary Number or change chart types and try again."
Help will be greatly appreciated.
Thanks
Answers
-
yes, you should add a calculated field that counts the number of rejected items you have.
SUM(CASE WHEN `RejectedStatus`='Y' THEN 1 ELSE 0 END)
Add a calculated field like this as a summary for the table and you can then create an alert that will let you know anytime that you have a rejected status. You can set the alert to go off once per day, everytime the dataset updates, etc. You can also specify if you want the alert to continue to send anytime it is in a triggered state, or if it should only be sent once.
You would then need to subscribe the right users to the alert.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
@ST_-Superman-_ 's solution works most of the times.
if it's unlikely that the total number of rejections would not be the same from day to day, THEN you can build an alert on it.
Imagine Trans_ID 16 was rejected. then today it goes to approved. Meanwhile Trans_17 goes from approved to rejected. Net change = 0. Disaster.
If it were me, I would build a recursive dataflow of rejected transactions.
Then every day, I would ask (via ETL), Is my snapshot from yesterday the same as my snapshot today?
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Well yes ST_Superman, that does work but again the issue is it does not give indication as to which of the line item got rejected actually, it gives a record count when chnaged. What I am looking to do is identify the exact line where the rejection happened and send out that line information to an email as an alert. Is that possible to do so here in alert settings or it has to be handled differently.
Thanks
0 -
jaeW_at_Onyx, thats right, +1 and -1 will even out and not provide right results.
Thanks
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 49 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive