Set Analysis! What the heck, part II?

[dpstanley_13]

Okay, so I'm back.  I had this resolved until I had to make it interactive with the rest of my data.  I have struggled with this all weekend, so I'm throwing this back out for assistance.

I need to have the "Median" and "stdev" columns calculate for each "Intervention" for the period of time defined by the last two columns of the table; "vMeasureInterventionCDStart" and "vMeasureInterventionCDEnd".

So, for the "Median", the value for "BASE" should be 14.8% and the value for "A" should be 10.6%.

I am attaching the app.

[sunny_talwar]

Try this

=Num(Median(TOTAL <MeasureInterventionCD> Aggr((Sum({<CommonMeasureNM=, CalculationTypeDSC = {'Rate'}, IsNumeratorFLG = {1}>} If(MI_YearMonth >= $(vMeasureInterventionCDStart) and MI_YearMonth <= $(vMeasureInterventionCDEnd), MeasureValue))/

Sum({<CommonMeasureNM=, CalculationTypeDSC = {'Rate'}, IsDenominatorFLG = {1}>} If(MI_YearMonth >= $(vMeasureInterventionCDStart) and MI_YearMonth <= $(vMeasureInterventionCDEnd), MeasureValue))),YearMonthCD, MeasureInterventionCD)),'#,##0.0%')

[dpstanley_13]

Once again, you saved the day!  Thanks!

[dpstanley_13]

Okay, I still have a problem.  I forgot to mention that I need to convert this back to a combo chart.  I was so excited that you answered so quickly, I did not see that you had added a second dimension.  This is the final outcome I need.  I only converted it to a table so that it was easier to see the values.  My apologies.

[sunny_talwar · Accepted solution]

Try this

=Num(Aggr(Median(TOTAL <MeasureInterventionCD> Aggr((Sum({<CommonMeasureNM=, CalculationTypeDSC = {'Rate'}, IsNumeratorFLG = {1}>} If(MI_YearMonth >= $(vMeasureInterventionCDStart) and MI_YearMonth <= $(vMeasureInterventionCDEnd), MeasureValue))/

Sum({<CommonMeasureNM=, CalculationTypeDSC = {'Rate'}, IsDenominatorFLG = {1}>} If(MI_YearMonth >= $(vMeasureInterventionCDStart) and MI_YearMonth <= $(vMeasureInterventionCDEnd), MeasureValue))),YearMonthCD, MeasureInterventionCD)), YearMonthCD, MeasureInterventionCD),'#,##0.0%')

[sunny_talwar]

This

[dpstanley_13]

Awesome!