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.