7 Replies Latest reply on Nov 26, 2018 8:39 AM by Norbert Maijoor

    Count the number of records based on another TC

    Yinglu Wang

      Hi everyone!

       

      I am new to Tableau and trying to figure out how to count the number of records based on another table calculation.

      Here's a screenshot:

      Screen Shot 2018-11-25 at 14.58.54.png

      The second column is a calculated field which is the difference of the timestamp of the current row and that of next row (in seconds). I want to count how many rows meet the condition that

      [time_diff]=-1 or [time_diff]>=180

       

      But I got this error when I use SUM()

      Screen Shot 2018-11-25 at 15.01.40.png

       

      I have been struggling this for long. Any insight will be helpful!

       

      Thanks,

      Yinglu