text object show the max date for current wait

[qliklizzy]

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

[jonathandienst · Accepted solution]

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

[tresesco]

I should have read your first post a bit more carefully. Try like:

=Interval(max({<EventUniqueID ={"=assessmentdatetime=Max(TOTAL assessmentdatetime)"}, MetricDesc=,MetricID={'LI01'},Status-={'DISCHARGED','COMPLETED','LETTER'}, Location-={'EAU'}, ReadyStatus -={''}>} EDReadyWait)/24/60, 'hh:mm')

[qliklizzy]

Thank you! so much

I don't understand it - no way could I have figured that out!

thank you again

Liz x

[qliklizzy]

its just returning -

thank you for you help, really appreciate it, Jonathon's reply has fixed the issue, you were on the right lines with firstsortedvalue

[jonathandienst]

I assume you are unsure about this bit:

EventUniqueID = P({<

  MetricDesc=,

  MetricID={'LI01'},

  Status-={'DISCHARGED','COMPLETED','LETTER'},

  Location-={'EAU'},

  ReadyStatus -={''}>

  }  EventUniqueID)

This set expression just selects the EventUniqueID values that fit with the selection criteria in your post. P() is possible values.

[qliklizzy]

arh thanks brilliant,

and the first sort value gives me the latest assessment date on that set expression

good to know! thanks

I have used this twice now already, very handy!