Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Could someone kindly help me write some set analysis. The below syntax works and is near to what I want to achieve, but I want to add some extra syntax in
I want to add where
=Time(RangeFractile(.95, $(=Concat([Total Wait], ',') & ',' & Concat(CONCLUSION_WAIT_MINS, ','))
This does not work
=Time(RangeFractile(.95, $(=Concat({<RunMonth = {$(=Max(RunMonth))}, [Patient Admitted?]={"1"} >}[Total Wait], ',') & ',' & Concat({<RunMonthEye = {$(=Max(RunMonthEye))}, [ADMISSION_FLAG]={"Y"}>}CONCLUSION_WAIT_MINS, ',')))/1440,'hh:mm')
[Patient Admitted?]={"1"} >} in front of [Total Wait] and [ADMISSION_FLAG]={"Y"}>} in front of CONCLUSION_WAIT_MINS, but the syntax returns a Null value
Can someone kindly help me put the right brackets in the right place to incorporate both [Patient Admitted?]={"1"} >} and [ADMISSION_FLAG]={"Y"}>}
Thanks
Helen
Hi Helen,
Your expression looks like it's ok...
You should try to break down the parts to debug it. So, what are the return values of the below expressions?
- Concat({<RunMonth = {$(=Max(RunMonth))}, [Patient Admitted?]={"1"} >} [Total Wait], ',')
- Concat({<RunMonthEye = {$(=Max(RunMonthEye))}, [ADMISSION_FLAG]={"Y"}>} CONCLUSION_WAIT_MINS, ',')
Hello Fernando,
Thank you for your reply. I will try debugging
Concat({<RunMonth = {$(=Max(RunMonth))}, [Patient Admitted?]={"1"} >} [Total Wait], ',') will return 02:03
and
Concat({<RunMonthEye = {$(=Max(RunMonthEye))}, [ADMISSION_FLAG]={"Y"}>} CONCLUSION_WAIT_MINS, ',') will return a null value
Thanks
Helen