1 Reply Latest reply on Jul 6, 2016 12:49 PM by Constance Barton

    Calculate amount of time using two date and time fields

    Jaspreet Narang

      Hello Everyone,

       

      I have a relatively simple data source that looks like below:

       

       

      As you can see I have 2 date and time fields. I want to achieve the following: Calculate the amount of time it took for one work item id to be finished and then display the average value of that time for each application. if average value is greater than 24 hours then status should be red.

       

      Below is a sample of how I want the fields to look like in Tableau:

       

      Application Name
      Volume(Total Number of Work Item ID's)
      Average Time
      Status
      MS Outlook10Calculated timeCalculated Status
      Skype5Calculated timeCalculated Status

       

       

      I have attached the data source also.

       

      Thanks and Best Regards,

       

      Jesse