1 of 1 people found this helpful
The fundamental premise of VizAlerts is that it will always send you an email on the schedule you select, if there is data showing in your view at the time the schedule is set for. If you are seeing data in the viz, and you subscribed to it on a schedule, it will not stop emailing you until the data disappears from the view. Because this is a demo workbook, the data does not update, ever--so nothing will change.
In real life, you would set a relative date filter against your data to prevent the sending of duplicate alerts. Something that filters the view of the revenue to say, the previous day only. You'd then subscribe on a daily schedule, probably in the morning, and if the previous days' revenue exceeded the amount set by your parameter, you would get an email. If not, no data should show, and you'd get no email. That's the basic idea, anyway.
If you're looking to be notified when a cumulative sales threshold is reached, such as a sales team achieving a quota target for a given quarter, it gets a little trickier. See this post for details on a way to achieve that: Example: Alert when a Sales Target is achieved
I agree. But it still send me alert even no data showing in my view since i
set threshold very high.
<http://www.rubylife.com> Kelin Liu
On Wed, Aug 3, 2016 at 1:34 PM, Matt Coles <firstname.lastname@example.org>
Oh, okay--I see now. Hmmm...are you setting the threshold in Tableau Desktop, or Tableau Server? If you are setting the threshold parameter in Desktop, so no data shows, then publishing to Server, you should definitely get no alert.
However, if publish it to Server with the data showing, subscribe to it, then adjust the parameter and save as a customized View, it will still be emailing you because the subscription is still pointed at the original view. You may need to delete that one, then load your customized view and subscribe to that instead.
Does that seem like what might be going on?
I'm looking at this from a computer formula viewpoint so wouldn't the formula INT(SUM(Revenue) > [montly_revenue_threshold]) produce either a 1 or 0 (zero)? It's converting a boolean value to an integer, right? If so, 0 (FALSE) is still a value and will be displayed and thus the rule of "if there is data showing in your view" will be true and the VizAlert will trigger. Instead of a zero it should be a NULL (i.e. nothing) value.
I set threshold in Desktop, then publish to Server.
So you mean formula should be "SUM(Revenue) > [monthly_revenue_threshold]"? Let me try, thanks,