3 Replies Latest reply on Oct 31, 2018 11:18 AM by Yuriy Fal

# Turnaround Time, with LOD

Hello,

I am trying to calculate turnaround time i.e. end time of a previous procedure to the start time of a subsequent procedure for a medical procedure area. The data set includes the date of the procedure, room (4 possible rooms), start time, end time, and doctor (sample workbook is attached).

I am trying to calculate two variants of turnaround time:

1) same day, same room

2) same day, same room, and same doctor i.e. the turnaround time would be calculated only if the preceding case on a given day in a given room was done by the same doctor

I am assuming this requires some LOD/nested LOD calculations but I'm not sure how to proceed. I have attached a sample workbook and would appreciate the Community's help.

Thank you,

Arsen

• ###### 1. Re: Turnaround Time, with LOD

Hi Arsen,

Since the calculation should compare data from different rows,

LOD expressions could be of little (if any) use.

But one could use Table Calculations instead.

Yours,

Yuri

• ###### 2. Re: Turnaround Time, with LOD

Thank you very much, Yuri. I had worked through it and developed a similar calculation. Is there a way to generate the same calculation without having to organize the data into a table?  i.e. the data would be loaded/refreshed and there would be an aggregate calculation (avg, min, max etc) for Turnaround time?

• ###### 3. Re: Turnaround Time, with LOD

Hi Arsen,

Even if there's a way, I'm not aware of it, sorry.

One can rearrange pills on a view,

choose a different viz type,

Hide (not Filter out) some Marks.

But one couldn't change the Dimensions on a view,

so the Visual Level-Of-Detail (VizLOD) to remain intact --

for the Table Calculations to work as expected.

If it could be possible to avoid Table Calcs

and make everything work with aggregates

(all without radically changing the datasource),

I would let you know immediately.

Yours,

Yuri