-
1. Re: Threshold alerting per category
Sankarmagesh Rajan Oct 31, 2017 3:13 AM (in response to Melody H)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
Melody H Oct 31, 2017 5:36 AM (in response to Sankarmagesh Rajan)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
ivan.li.0 Oct 31, 2017 8:04 AM (in response to Melody H)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!