9 Replies Latest reply on Aug 29, 2016 5:37 AM by Benjamin Greene

    Count recurrences by Date and Type

    Gurpreet Singh Goraya

      Hello Tableau community,


      I am trying to calculate the number of recurrences by Absence type and their count. For an example:


      ID 6001 has 6 counts of ATUREP-F and a total number of discrete occurrences are 3. (The first incident on Jan 6 & 7, the second on March 21 and the third happened on March 18,19 and 20). I will consider as one recurrence if there is a consecutive date. I have attached the sample spreadsheet. Please let me know if you need more explanation. Thanks in advance