Alert when value changes

Question & Answer
1

Hi,

I have a KPI that is just a count. I want to be able to alert every time that count changes.

So if it is currently 2, I want to know when it goes to 3, 4, 5, etc.

The nearest I can get is doing the following:

  1. Create a new alert
  2. Select Condition “is above:”
  3. Set Threshold to 2

HOWEVER, this means that every time the data refreshes and the value has incremented to 3, it will alert. Even if this value stays at 3 for 7 days, it will alert 7 times, for example.

What I want is a way for it to just alert me once when the value changes to 3, then just alert me once when the value changes to 4.

It would be something like Condition “has changed” with no Threshold needed.

Does anyone have a workaround for this?

Thank you!

3

You should choose daily at most

  • Daily at most - This option alerts you once per day when the threshold is breached.

image

1 Like
4

Totally understand, but that would not work for this use case.

Example:

  • At 10am Monday, the value increments to 3. I want to know at 10:01 am that it has incremented to 3.
  • At 1:23pm Monday, the value increments to 4. I want to know at 1:24pm that it incremented to 4.
  • At 9:07am Thursday, the value increments to 5. I want to know at 9:08am that it incremented to 5.

With the suggested solution, this is what would happen:

  • Tuesday morning, I would get notified that the value is 4.
  • Wednesday morning, I would get notified that the value is 4.
  • Thursday morning, I would get notified that the value is 4.
  • Friday morning, I would get notified that the value is 5.

Basically, I suppose i am asking for something similar to real-time alerting. Or once hourly alerting, since my dataset only updates once per hour.

5

We have following options available and if this will not help then we need some workaround , plz let me know if following three is not helpful in your usecase ?

  • As frequently as possible - This option alerts you whenever the threshold is breached. If you choose this option, you might get alerts multiple times a day.

  • Daily at most - This option alerts you once per day when the threshold is breached.

  • Weekly at most - This option alerts you once per week when the threshold is breached.

1 Like
6

@bhamplify
To me it looks like it’s not just a scheduling issue. The threshold in the alert is a static value but in your case, you want the threshold to increase to the new count every time it increases. Am I understanding this correctly?

7

Do you have a date in your dataset? If so, you can try to calculate a running count based on that date and set up the alert based on the difference being greater than 0.

image
image1807×389 33.6 KB

1 Like
8

The threshold in the alert is a static value but in your case, you want the threshold to increase to the new count every time it increases. Am I understanding this correctly?

Yep! And that running count is a great idea, thank you. I think I can do that for now, but will need to go outside of QuickSight for a real-time alerting solution, since that is not really QS’s purpose.