1 Reply Latest reply on Oct 23, 2018 2:50 AM by kumar.c

    Calculate the number of rows less than a certain value

    Penn Wang

      Hi Everyone,

       

      I'm very new to Tableau. I have created a calculation [DIFF] to return the difference between two date&time columns by the formula below:

      DATEDIFF('minute',[Time1], [Time2])

       

      Now I want to calculate the number of records that has a value less than -6?

       

      This is what I wrote but didn't work. Please tell me what's wront?

       

      IF (SUM([DIFF])) <=-6

      THEN(SUM([Number of Records]))

      END