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.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 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
- 176 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive