3 Replies Latest reply on Oct 31, 2017 8:04 AM by ivan.li.0

# Threshold alerting per category

Hi guys,

I have a question regarding threshold alerting per category, As I know, tableau already has a threshold alert function like this. But what i want is I want to set an alerting for each category (because each country has different threshold, e.g New York: \$30K, Los Angeles \$10K and if they reached it, I will get a notification). Do you guys now how to do it?? Thanks in advance!

• ###### 1. Re: Threshold alerting per category

Hi Melody,

Are you looking something like this

if attr([State])='New York' and sum([Sales])>30000 then 'New York Sales exceeds 30k'

elseif attr([State])='Texas' and sum([Sales])>=10000 then 'Texas Sales exceeds 10k'

END

Thanks

sankar

• ###### 2. Re: Threshold alerting per category

Hi Sankar,

Yes, but I want to get an email alert if it reached the threshold. Is that possible?

Regards,

Melody

• ###### 3. Re: Threshold alerting per category

Hi Melody,

Haven't had too much exposure to the alerts function yet - but if it is calc based, perhaps we could try this:

Create a calculated field based on Profit, with a condition on the category:

CASE ATTR([State])

WHEN "New York" THEN IF SUM([Profit]) >= threshold1 THEN 1 END

WHEN "..." THEN IF SUM([Profit]) >= threshold2 THEN 1 END

END

Something along the lines like that.. then you can trigger the alert based on this calc. I've selected for a numerical output as I recall the data alert is driven by a continuous axis.

Let me know if this works!