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]))