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

    Threshold alerting per category

    Melody H

      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
          Sankarmagesh Rajan

          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

            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

              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!