I would like to get an alert when a session has no data, but the alert should happen only if data has been missing for 3 or more consecutive days.
Please see the below image. I label the sections with the letter A, B, C, D using a blue pen.
On A: I do not get any alerts, because there are no 3 consecutive days.
On B: I do not get any alerts, because there are no 3 consecutive days.
On C: I get only 1 alert, I get an alert on 2/4/2014, because this day is the third consecutive day (after 2/2 and 2/3).
On D: I get 2 alerts, one on 1/30 and another on 1/31, because 1/30 is the third consecutive day, and 1/31 is the fourth consecutive day ( 3 or more consecutive days)
The results should look like this image below
Thank you so much in advance
Hope this helps.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...