5 Replies Latest reply on Aug 15, 2013 7:15 AM by Nkosi Smart

    Table Calculation to difference of one cell and a previous value in a different column

    Nkosi Smart

      Hey all!

       

      Trying to see if this calculation is possible with Tableau. Some background info : my client wants to generate a report using data from their time and attendance solution.

       

      The aim is to get a report that shows when an employee swiped out for lunch and when they swiped back in - to crack down on latecomers. I'm wrecking my brain trying to figure out how to get this calculation but to no avail - so I'm hoping that you guys can possibly give me a hand or tell me if it's not possible. The company info is sensitive, so i've attached a screenshot of what I have so far. If it's not enough I'll ask if i can divulge a snapshot of the information.

       

      Thanks in advance!!