8 Replies Latest reply on Aug 1, 2018 12:12 PM by Soham Wadekar

    Create calculated group that counts dates once

    Andre Romain

      Hello Tableau Community,

       

      I am trying to calculate a way that counts days only once in a situation where more occurrences of that date exist. For example,

       

      Event Start: 8/1/2018 11:00AM

      Event start: 8/2/2018  12:00PM

      Event Start: 8/2/2018  4:00PM

       

      In this instance, I have 3 dates, so when I ask Tableau to bring me the number of records, it brings me 3. But only 2 of these dates are unique, so I only want an answer of 2. How would I do this?

       

      Please note: I will be having multiple difference locations and the different locations can have the same date; I just can't have the same location with the same date.

       

      I have an attachment for a more precise example.

       

      Thanks!