3 Replies Latest reply on Oct 1, 2018 4:12 PM by Ken Flerlage

    Distinct Count of ID's with the same Start and End Days

    Michael Ejigu

      Hello,

       

      I recently began using tableau and had a quick question I'm trying to write a function that would halp me Count the number of distinct order ID's when the start time (order que date) equals terminate time (order completed date). Here's the formula i'm using but unsuccessfuly:

       

      COUNTD(IF([StarttimeAsDate]=[Today])THEN 1 ELSE 0

      AND

      If([TerminatetimeAsDate]=[Today] )THEN 1 ELSE 0)

      END

       

      Could anyone tell where I'm going wrong with this formula?

       

      Thanks,

      Mike