Aggregation in Variable

[#1]

Hi folks,

i am stuck with below issue and have tried lot of different stuff but cant solve it.

I am Plotting a Bar graph with below details

Dimensions

1) Facility and 2) Days_To_Readmit

Measure

1) count(encounters) per days_to_Readmit / Count(encounter) group by Facility for all Days_to_readmit

I created variable which will store denominator part and give me total encounter, issue is variable is giving me total combining all the facility present, where as i want it by each facility.

e.g. if total encounters for Facility 1 is 20 and Facility 2 is 100 than bar should be plotted for each facility as Numerator of Facility1/20 and Numerator of Facility2/100 right now it is coming as Numerator of Facility1/120 and Numerator of Facility2/120

i have attached the app as well, your help would be much appreciated.

Thanks

[tresesco]

Corrected the variable definition. PFA

[#3]

Hey Tresesco,

Thanks for reply, i am not able to open your document.

Please let me know what changes you have done.

Regards

[tresesco · Accepted solution]

Variable definition:

Aggr(NODISTINCT count({<DISCHARGE_DATE_DT={">=$(vMinDate)<=$(vMaxDate)"},INDEX_READMIT_FLAG={I}, DAYS_TO_READMIT=>}ENCOUNTER_QO_KEY),Facility_Name)

Note: no '=' in front.

And '$' sign before variable name in the expression like: .......TER_QO_KEY)/$(Encounter_Count)

[#5]

Thanks tresesco really appreciate your help.