There's no data that VizAlerts can use to determine if the alert has already been sent or not, unfortunately. However, there are other tricks you could employ.
- Is the extract it depends on local to the workbook, or is it a published data source? If the former, then the latest version of VizAlerts has a feature where you can schedule the alert to run when the extract refreshes, rather than on a time-based schedule.
- You could simply push the schedule back to when the extract was certain to have run by.
- You could build a calc to represent a datetime value for when the refresh last ran. For example, you could use an LOD calc against the data your alert viz is built on that simply looks for the maximum date value across all the records. If there is nothing from the last 24 hours, then you could assume that the data has not been refreshed yet, and the alert shouldn't be triggered.
- You could work with your admin to connect to the Tableau Server repository database directly, and blend information on extract refresh times into your Action calc. It'd be something like "if my alert condition is true, and the max successful refresh time for the extract was in the last hour, then send the alert".
Let me know if that helps.
I'll try these options out and report back. Thanks!
Hi Jose. If this answered your question, would you mark my answer as correct, please?