Median without AGGR: Performance Issues

[#1]

Hi All,

In my dashboard i am calculating median value for No of days spent at hospital for patients as per the drugs,

So the metric which i am using is :

median(aggr([No of days],Patient,Drug))

But this is really killing the performance of my dashboard.

Does anyone has any other alternative for this median calculations without using AGGR functions.

Regards

Khushboo

[#2]

Hi Sunny,

Left Join (Table)

LOAD Drug,

Patient,

Time,

Only([No of Days]) as Temp1

Resident Table

Group By Drug, Patient,Time;

If we group by time also , we can have the correct median.

Any thoughts on this?

[sunny_talwar]

Then without selection of time, you will have more than one medians.... not sure what the expectation with and without selection is