2 Replies Latest reply: Dec 4, 2012 4:03 AM by Helen Pippard

# Set analysis Problem-Where to add in extra set analysis

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

This Works

=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')

I have added in the following

[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

• ###### Re: Set analysis Problem-Where to add in extra set analysis

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, ',')

• ###### Re: Set analysis Problem-Where to add in extra set analysis

Hello Fernando,

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