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: