Alert set up

vaco · July 17

Hi, I have a card that is filtered by product_id. I want to set up an alert, so that if the calculated rate for any product_id is less or equal to 10% then I get an alert. For example, there are 3 product_id 10, 11, 12, and the calculated rate is the summary number. I set up the alert, but it looks like I am getting the alert for the average rate of the 3 product ids. Is it possible to set up the alert to get notification for each product_id if the rate is less or equal than 10% using 1 card or do I need to create 3 cards? Thanks

DanHendriksen · July 22

Something like this. Obviously I just chose something random, but this is how you create a filtered alert on a dataset.

david_cunningham · July 17

What you want to do is create a beast mode that creates a flag of 1 when your condition is met. Then use an aggregation of that beast mode in your summary number, and set the condition of the alert to be when > 1.

vaco · July 17

Thanks @david_cunningham , I tried to create a beast mode but it is not working. Maybe the issue is my beast mode. Please see the beast mode below. I get 1 for everything, but it should be 0 because all the rates are greater than 10%.

case

when (case when `product_id` = 10 then `Rate_calc` else 0 end) <= 0.1

or (case when `product_id` = 11 then Rate_calc` else 0 end) <= 0.1

or (case when `product_id` = 12 then Rate_calc` else 0 end) <= 0.1

then 1

else 0 end

DanHendriksen · July 17

Vaco, if I wanted to do this, I would probably quickly create a dataset view that had the aggregated view you wanted, then create a dataset alert with filter rules. THen you could get an alert that says something like:

Product 3 has dropped below 10%, and is currently at 8%. Something far more descriptive.

If you want to fix your best mode, I'd ditch all the nested case statements. That isn't going to allow your alert to tell you which product is off though, which is what it sounds like you're after.

vaco · July 19

thanks @DanHendriksen , I created a test dataset first to see if it works, but the alert setting is the same. In this case the aggregated column is profit margin, so I selected profit margin and then sum because I don't see the option for no aggregation. There is no option for me to select product_id. Please see the images below. thanks

alert.PNG

alert 2.PNG

alert 3.PNG

DanHendriksen · July 22

I would use the options up higher in screenshot 1, and would do it around a value changing and a filter.

vaco · July 22

Hi @DanHendriksen , I don't understand your explanation. There is no place in alert to add a filter, and the alert is now on the dataset not the card. Thanks

DanHendriksen · July 22

Something like this. Obviously I just chose something random, but this is how you create a filtered alert on a dataset.

vaco · July 22

Great! thanks @DanHendriksen!

Alert set up

Best Answer

Answers

Categories