You're going to have to help us out here by providing some data.
Please can you pull something together in Excel with your expected output so we can re-create in Tableau.
Thanks for your quick response, Steve!
Basically I am trying to set up another sheet to give the following:
The 'Average # of days in Status' column should take the Initiated --> Requestor Assigned days from each row, total them and calculate the average.
The caveat here is that I have the date field and the 'Days since previous Date' (last column in my original post) is a calculated field with the following formula:
IF(ISNULL(DATEDIFF('day', LOOKUP(MIN([Update Date]),-1), MIN([Update Date])))) THEN 1
ELSE(DATEDIFF('day', LOOKUP(MIN([Update Date]),-1), MIN([Update Date])))
Any help would be appreciated. Thanks!
You posting calcs have little to no context as we have no-way of applying them.
As I said, please can you attach an Excel workbook, it doesn't have to be real data, just something where we can see the raw data and then the expected output, this way we can advise on exactly what it is you are wanting.