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?

  • rahul93
    rahul93 Contributor

    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.

  • guitarhero23
    guitarhero23 Contributor

    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.**
  • rahul93
    rahul93 Contributor

    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.

     

This discussion has been closed.