11 Replies Latest reply on Jul 27, 2016 4:26 PM by Jonathan Oakleigh

    First 100 records of a dataset

    Jonathan Oakleigh

      Hello,

       

      I have a data source where each row/record has a timestamp attached to it.

       

      I need to develop a simple query where Tableau returns the date range (or DATEDIFF that the first 100 records occurred within)

       

      For example, let's say my dataset contains 200 rows that have timestamps from 15:00 to 17:00 in one day.

       

      The first 100 timestamps in the dataset occurred between 15:00 and 15:59.

       

      In this case, I would like the query / function to return 59mins as the  DATEDIFF.

       

      Hopefully I have explained that clearly enough?

       

      Any help greatly appreciated.

       

      -Jono