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 Outlook||10||Calculated time||Calculated Status|
|Skype||5||Calculated time||Calculated Status|
I have attached the data source also.
Thanks and Best Regards,
To compute elapsed time, you can create a calculated field using the formula
Compute in minutes then divide by 60 to show portions of an hour.