5 of 5 people found this helpful
1. No. The check will run hourly, even when you pick "daily at most". When you pick that, and it is triggered, any further alerts are suppressed until 24 hours later. So the alert will not run at a specific time each day, but will end up "drifting" over time due to the way the suppression is being handled.
2 & 3. Yes. But you might consider Conditional Subscriptions as an out-of-the-box solution. It would allow for the same kind of conditional alerting you want, but it will run when you schedule it--namely, the Schedule you pick for the subscription. VizAlerts would be something to look into when you also want to email a dynamic set of recipients based on certain data conditions and/or customize the content and attachments within the emails themselves.
Matt - Thank you for the response to Christopher's original question. As I had a similar question/issue with the data alert schedule I wanted to add to this discussion.
I have a dashboard that updates daily but at different times each day as my source data comes from another program and the run time varies by day.
I have multiple refreshes daily (every 15 minutes between 7am and 10am) and when the data is updated this is picked up in one of these refreshes, but this can be at a different time each day.
I created an 'invisible' chart within my dashboard based on a calculated field which is the max date within the source data set compared to today's date. I was able to set a conditional alert to generate an email if the value is one or less (meaning data from prior day is now available) and set it to fire daily at most. This worked the first day, similar to Christopher's experience, but not immediately on the second day.
I expected the daily alert to reset each day at midnight - not every 24 hours. As explained in Matt's response above, this alert will only trigger after 24 hours have passed, when I need something that will trigger daily on the first instance each day, even if if is less than 24 hours from yesterday's alert.
I would suggest that there should be two options here - one option for the alert to trigger once every 24 hours (which is the existing option) and one every day (resets at midnight), which would allow the first instance the trigger fires each calendar day to generate an email.
I agree that it would be nice to relabel "once every day" to "once every 24 hours" since it's more explicit
Additionally, I think it would be helpful to have a true "once every day" option with options for resetting at X time on Y timezone. Or if the Y timezone is not possible, because the nuances of timezones are more complicated than everyone realizes, at least display the server timezone which I assume the reset every day at x time would key off of.
Thank you for your reply Matt. You have answered my original questions and any follow up questions I'll put into a new thread.