Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
I have a cohort of people showing the time they came in and their associated EDwait
I have a text box that shows the number of these patient's waiting
=count({<MetricDesc=,MetricID={'LI01'},Status-={'DISCHARGED','COMPLETED','LETTER'}, Location-={'EAU'}, ReadyStatus -={''}>} EventUniqueID)
the other box I need to show what the last persons wait was.. so I need a max of date but show the EDwait if you like ?
I tried this:
=Interval(max({<MetricDesc=,MetricID={'LI01'},Status-={'DISCHARGED','COMPLETED','LETTER'}, Location-={'EAU'}, ReadyStatus -={''}>} EDReadyWait)/24/60, 'hh:mm')
but this just gives me the max EDwait for all of those people. I cant figure out how to add in the max date
thanks
Give this one a shot:
FirstSortedValue({<
EventUniqueID = P({<
MetricDesc=,
MetricID={'LI01'},
Status-={'DISCHARGED','COMPLETED','LETTER'},
Location-={'EAU'},
ReadyStatus -={''}>
} EventUniqueID)
>} EDReadyWait, -assessmentdatetime)
Wrap this expression in an interval function if required
What this returns when you use below one?
max({<MetricDesc=,MetricID={'LI01'},Status-={'DISCHARGED','COMPLETED','LETTER'}, Location-={'EAU'}, ReadyStatus -={''}>} EDReadyWait)
Hi
this just shows the max value of EDready wait.
So if there was 10 people who are ED ready it shows the longest wait,
however I need to refine it to the last person who came in , so max date and bring back their EDready wait
thanks
Try using FirstSortedValue(), like:
=FisrtSortedValue({Set analysis} PatientField , -EDreadyWait)
How do you identify the last person who came in (ie which field and what does the field contain)?
assessmentdatetime is the time they came in,
I need a max of this, on the set analysis, bringing back the edready wait
thanks
thanks
this doesn't work.. I get a big number..
do you mean paitentfield is the date I need the max applying to?
=FirstSortedValue({<MetricID={'LI01'},Status-={'DISCHARGED','COMPLETED','LETTER'}, Location-={'EAU'}, ReadyStatus -={''} >} AssessmentDateTime , -EDReadyWait)
May be this?
=FisrtSortedValue({<MetricID={'LI01'},Status-={'DISCHARGED','COMPLETED','LETTER'}, Location-={'EAU'}, ReadyStatus -={''} >} PersonField , -assessmentdatetime)
sorry was is person field?
thanks
sorry I edited my first reply to you, as I had first spelt incorrectly.
it returns a big value, where I need it to display time.
so I applied interval to it but it still doesn't retrieve the right answer.
the last person in should be 00:18 but I get 718:49
=interval(FirstSortedValue({<MetricID={'LI01'},Status-={'DISCHARGED','COMPLETED','LETTER'}, Location-={'EAU'}, ReadyStatus -={''} >} AssessmentDateTime , -EDReadyWait)/24/60, 'hh:mm')