this is one of those times when a sample workbook would really help me give you a good answer.
Can you hack up an anonymized workbook so we can have something to work on together?
Check out this link:
When I compare things to the prior row, I usually have a special part of the calc that forces what I want into that first instance.
IF INDEX() = 1 then ...
(all the rest of your stuff...)
Hi Joe and Tableau Community:
Many thanks for reviewing and your helpful suggestion to include a workbook! It is attached.
Ideally, I like to see the turnover time (end exam time to begin exam time) for a first case of the day, for a specific radiology machine, as always zero (0).
Can you assist me with using an Index and the computation for that?
Also, as you might see in some of the output, some subsequent cases for a machine on a given day have "begin exam" times that occur before the "end time" of a previous case (user input error, I guess). This is presently resulting in 0 - not what I want.
Any recommendations on how to best exclude instances when that happens or other workaround suggestions?
Many thanks for any help and ideas. I'm using 10.5
TabCommunityTOT.twbx 55.0 KB