max of date returning associated value

[qliklizzy]

hi

i am stuck on this piece of code

=max({<MetricDesc=,MetricID={'LI01'}, StatusExclude={'No'},Location-={'EAU'},EDready={'Y'}>} EDreadyTime)

this gives me the maximum datetime entered, but i want it to return the associated waittime.  this field= PreEDReadyWait)/24/60, 'hh:mm')

how to i achieve this?

thanks for your help

[Anil_Babu_Samineni]

What you want to achieve, Would you provide sample. And expected o/p

[sunny_talwar]

May be this:

=FirstSortedValue({<MetricDesc=, MetricID={'LI01'}, StatusExclude={'No'}, Location-={'EAU'}, EDready={'Y'}>} PreEDReadyWait)/24/60, -EDreadyTime)

[qliklizzy]

i have just made a table to show you this; but also noticed i am missing those who have no location - so i need to fact these in also.

basically I want to show the Pre ed ready wait for the latest patient on there who is ED ready:  so the result should be: this person at  06/10/16 15:55 and i need to bring back their wait which is 220 minutes (in hours and mins)

hope this makes sense, thanks for looking

[qliklizzy]

thanks for your reponse;  this didnt work im afraid - i have pasted a table and explanation on the previous post to hopefully explain where im coming from.

thanks again

[sunny_talwar]

I don't see any table in your post above?

[qliklizzy]

i just inserted a picture?

[sunny_talwar]

I am seeing this (no image)

[qliklizzy]

ahhh its currently being moderated ?

[sunny_talwar]

I guess we will wait until it gets approved