8 Replies Latest reply on Sep 9, 2018 2:00 PM by Hari Ankem

    Default Time stamps

    john anil

      Hello Tableau Gurus,

      I am wondering How to create default time stamp in tableau?

      I have data which is not properly distributed and need to assume own rules.Time stamps in data don't have few dates and need to create in Tableau.

      Each worker has TIME IN, WORK TIME and TIME OUT columns, where ever time is not recorded then Tableau need to record the value.

      Rule1(Worker1)- TIME OUT is Null or not recorded then assume  last WORK TIME as TIME OUT time

      Rule2( Worker2)- Both WORK TIME and TIME OUT  are Null or not recorded then assume last TIME IN as WORK TIME and TIME OUT time

      Rule3(Worker3)- Only TIME IN recorded then ignore WORK TIME show TIME IN as TIME OUT  value

      Any Ideas how to solve this scenario.?