4 of 4 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.