Alert Not Showing Same as Card is built
My card is a heatmap card with a row for different accounts and columns for the last 12 months of data grouped by month.
I have an alert set on it so that if any accounts most recent month of data = 0 to alert on that.
However somehow when the alert triggers I get results from the same account multiple times.
Example (What I expect to get):
- Account 1: Previously 900, Currently 0, Change -900
- Account 2: Previously 3010, Currently 0, Change -3010
- Account 3: Previously 400, Currently 0, Change -400
Example (What Domo says):
- Account 1: Previously 450, Currently 0, Change -450
- Account 1: Previously 200, Currently 0, Change -200
- Account 1: Previously 400, Currently 0, Change -400
- Account 2: Previously 3010, Currently 0, Change -3010
- Account 3: Previously 300, Currently 0, Change -300
- Account 3: Previously 850, Currently 0, Change -850
I'm not sure if the values themselves are summing up to something specific but unsure why I get multiple rows of the same account when the card is built to only show one row per account because the value of the box is a Summed value from a calculated field
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**
Comments
-
Is anyone able to help out with this request?
0 -
Hi,
I have been playing with alerts a lot recently, it is a tricky beast to understand. But as a FYI, alerts get triggered when the dataset loads/reloads.
I am not sure what the issue could be here as it depends on the dataset. But, if you are using a beast mode to sum the values of the calculated field then i think that could be the issue as to why you are seeing multiple lines for the same account.
Let me know if that is not the case.1 -
I know that Alerts have the option of being triggered based on the dataset being updated however on this card alert specifically I had it set for the last day of the month, and the never shows multiple rows for the same account...seems fishy.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
Oh! So if its the last day of the month, i think it shows you the changes that gradually made the number what it was when the alert is set to trigger. Do you think that could be the case? Like i said its a little tricky to understand whats going on if you dont monitor it between 2 alerts.
0
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 338 Workbench
- 250 Domo Best Practices
- 11 Domo Certification
- 460 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有