Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm currently working on a physician scorecard for our system using reference lines for standard deviation.
I'm trying to get the reference line to work with the filters where users can drill down to EntityName, PrinProcMDName,FiscalYearMonth
My set analysis is below:
=Stdev(Aggr(Sum(Distinct DirectVariableSalaries)
/Count(Distinct PatientAccount),EntityName,PatientAccount))
Any help is appreciated.
Thanks!
Hi Kimberly,
If you include PrinProcMDName and FiscalYearMonth as fields in your Aggr() function (in addition to EntitityName and PatientAccount), when the user drills down by, e.g. FiscalYearMonth, on your chart, the current selections will be limited to the respective FiscalYearMonth. This will then be reflected in your aggregation i.e. the aggregation will only be performed over data for that FiscalYearMonth and your line should reflect this.
Does this work for you?
Padraic
Hi Kimberly,
If you include PrinProcMDName and FiscalYearMonth as fields in your Aggr() function (in addition to EntitityName and PatientAccount), when the user drills down by, e.g. FiscalYearMonth, on your chart, the current selections will be limited to the respective FiscalYearMonth. This will then be reflected in your aggregation i.e. the aggregation will only be performed over data for that FiscalYearMonth and your line should reflect this.
Does this work for you?
Padraic
Hi Padraic,
Yes, Once I added them in there, it's working as I intended! Thanks so much!!