1 Reply Latest reply on May 8, 2013 12:32 PM by Mark Holtz

    Duration Calculations

    Travis Eck

      I am fairly new to Tableau but up to this point have been able to create the calculations I need but this one has me stumped. I need to be able to look at a current week for all Employee ID's Field Name EMP ID and then calculate the duration in weeks or months between the earliest date where the EMP ID appears and the current week.

       

      I have attached a data sample and the report will be evaluated on a weekly basis. Any help will be greatly appreciated.

        • 1. Re: Duration Calculations
          Mark Holtz

          Hi Travis,

           

          Sorry this went unanswered for so long.

          Since you do not have the "Start Date" for the EMPID in your underlying data (which would make this simpler), you have to create a table calculation using WINDOW_MIN and edit how it calculates so that it resets for each EMPID.

           

          Then, you only want to display the most recent week for each EMPID, so that's what the "Last" field does in the filter.