Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
Then without selection of time, you will have more than one medians.... not sure what the expectation with and without selection is