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.