

2. Re: Calculation for Missing Values
Elie Rahi May 8, 2018 10:38 PM (in response to Zhouyi Zhang)Hello,
my apologies I uploaded the incorrect data. Please see attached the correct one.
The median duration for parents with "Checked out at session end" = 0 is 0.7 hours. The duration times for "Checked out at session end" = 1 are all incorrect. Hence I am estimating the duration by using the median. So in other words I need the duration times for parents with "Checked out session end" = 1 to be all 0.7. And similarly for siblings, patients etc. But siblings, patients.. have all different median durations

Duration.xlsx 2.5 MB


3. Re: Calculation for Missing Values
David Maning May 8, 2018 11:07 PM (in response to Elie Rahi)1 of 1 people found this helpfulHi,
Please find the solution below:
{ FIXED [Type Visitor (orbit)] : MEDIAN(
IF [Checked out at Session end]= 0
THEN [Duration (hours)]
END)}
Please mark as correct and helpful closing this thread.
D

4. Re: Calculation for Missing Values
Elie Rahi May 8, 2018 11:46 PM (in response to David Maning)Hi David,
Thank you! I've used your LOD calculation in another calc:
IF [Checked Out at Session End] = 1 THEN [LOD]
ELSE [Duration]
END
This is what I was after.