21 Replies Latest reply: Jul 4, 2017 7:19 PM by Sunny Talwar RSS

    Median without AGGR: Performance Issues

    khushboo Peswani

      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