2 Replies Latest reply on Aug 3, 2018 7:52 AM by Stephen Groff

    LODs of problems - COUNTD - But I can't - So How?

    Stephen Groff

      I have a list of [Event #]... thousands of them.

       

      Because of joins and recurring data, I have duplicate events.

       

      [Event #] = lots of duplicates

       

      Attached to about 45% of these [Event #] is the [Wait Time]

       

      So 2 columns Event # and Wait Time...

       

      I have a calculation that SUM[Wait Time]

       

      Because I have so many duplicated [Events], the sum of the total [Wait Time] is completely wrong.

       

      I'm trying to drag the measure [Total Wait Time] on to the label card, and it works but it's wrong...

       

      In my head this works, but in Tableau, this is impossible:

      { FIXED COUNTD([Event #]):SUM([Wait Time])}

       

      Does anyone know how I can sum the total [Wait Time] for each distinct [Event]?  I "can't use an aggregated expression as a dimension, because it is a measure."

       

      Thanks folks!