1 Reply Latest reply on Feb 12, 2019 10:47 AM by Shinichiro Murakami

    Count only if data has been missing from 3 or more days

    Silvana Weinaug

      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 2/4 I lookup back in time one day and ask is this the +2 consecutive day? If yes, then count it.

      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