Hi,

Are you looking to set up Tableau's built-in data driven alerts for this or VizAlerts?

Jonathan

I'd suggest using an Advanced Alert for this, for me at least it's simpler than a simple alert. This is also because I'm imagining the rule is a little more complex, for example is the alert to be based on the most recent month, average across all months, or something else?

The Advanced Alert starts with a trigger view that has the Email To/From/Subject/Body/Attachment fields, so it has one record per alert (that might be sent to  multiple users at once depending on how you've configured the Email To field). Usually I just build this in a crosstab because it's easier to see validate what it's doing.

The threshold condition would be created by a calculated field on your data that implements the necessary rule. For example I might build a trigger view that is already filtered for the most recent month's data and then build a calculation like CASE ATTR([team]) WHEN 'a' THEN [warm transfer] < .9 WHEN 'b' THEN [cold transfer] > .4 END. Once the calc is validated then that goes on the Filters Shelf.

The advanced alert would then have a content reference that is either a VIZ_IMAGE() (in the Email Body or Email Attachment) or VIZ_PDF() (in the email attachment) that points to the dashboard that you want to send.

After the trigger view is published to Tableau Server you (as the trigger view owner) would subscribe the trigger view  to a VizAlerts schedule. Then what happens is:

VizAlerts downloads the trigger view based on the schedule.

If the trigger view has no data then nothing happens.

If the trigger view has any records then VizAlerts processes each record as an alert - downloading all the necessary content references and sending out the emails/texts/etc.

Does that answer your question?

Jonathan

Just a reminder that since v2.1.0 came out, you don't need to hide your data any more. You can simply code the Email Action calc to return a 1 for "trigger the alert" or a 0 for "do nothing". That way your data is always present on the viz, and you can throw that field onto the Color shelf or what have you to see what would trigger the alert, when you play with various filters. Easier to troubleshoot and prettier to look at!

Hi Anthony Chamberas! This Group is reserved for discussions around VizAlerts, an open-source, community-supported conditional email bursting tool for Tableau. As your content is not related to it, I've removed your post.