3 Replies Latest reply on Oct 26, 2018 9:01 PM by Ritesh Bisht

    add value to Time

    jon rios

      i have multiple records for the time down to the seconds, i wanted to add a additional distinguishing number (like a milliseconds marking), i dont have access to the data so I need to do this in Tableau..

      here is an example.  is there a calculation that will add an incrementing number to values that are similiar,

       

      If  [time] = PreviousValue( [time]) then [time] + 1

       

      current data

      9:30:02

      9:30:02

      9:30:03

      9:30:03

      9:30:04

      9:30:05

      9:30:05

      9:30:05

       

      end result i want

      9:30:02:1

      9:30:02:2

      9:30:03:1

      9:30:03:2

      9:30:04:1

      9:30:05:1

      9:30:05:2

      9:30:05:3