Fractile and Aggr function performance improvement

[vivekocbc]

Hi All,

I have an application which has data of 13GB in which we are showing various statistics like mean, SD the issue is due to such large volume it is taking too long so, as a part of performance enhancement program we would like figure out if there is a way to make it faster.

As per my understanding AGGR function makes performance of dashboard slow so, would like to understand if we can make this below expression faster.

Fractile(Aggr( if(sum(DAILY_DEBIT_AMT)=0,Null(),sum(DAILY_DEBIT_AMT)/sum(DAILY_CREDIT_AMT)) ,AggDimMonthly),0.99)

To explain above expression, we are showing various fractile like 99%, 95%, 90%, 84%, 75%, 50% as separate bars like below chart.

Can you suggest a way to improvise above expression to make it faster and we cannot compute it script level because we want values to be computed dynamically based on filters.