Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm currently using below expression to get the Revenue >=95 % values
This is working fine.
Now the ask is how to modify this expression to show values between 5 and 95 % values.
Please help
Expression:
=Sum({<RecordID =
{"=Sum([Revenue])
<= Fractile(TOTAL Aggr(Sum([Revenue]), RecordID), 0.95)"}
,
FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=
>}[Revenue])
Thanks
Satish
This
=Sum({<RecordID =
{"=Sum([Revenue]) >= Fractile(TOTAL Aggr(Sum([Revenue]), RecordID), 0.05) and Sum([Revenue]) <= Fractile(TOTAL Aggr(Sum([Revenue]), RecordID), 0.95)"},
FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=
>}[Revenue])
Hi Sunny
I have an issue here.
If i lasso on the bubbles, the chart is not displaying any value.
I think we are using TOTAL in fractile which is ignoring the dimension.
If i remove TOTAL the chart is going back to the initial state and no even distribution happens.
Could you please help me on the same?
Thanks
Satish
You can refer the same thread which has sample application
What about this?
=Sum({<RecordID *=
{"=Sum([Revenue]) >= Fractile(TOTAL Aggr(Sum([Revenue]), RecordID), 0.05) and Sum([Revenue]) <= Fractile(TOTAL Aggr(Sum([Revenue]), RecordID), 0.95)"},
FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=
>}[Revenue])
Hi Anil
No luck.
Thanks
Satish
You might need to ignore selection in Fractile function
=Sum({<RecordID =
{"=Sum([Revenue]) >= Fractile({1} TOTAL Aggr(Sum({1} [Revenue]), RecordID), 0.05) and Sum([Revenue]) <= Fractile({1} TOTAL Aggr(Sum({1} [Revenue]), RecordID), 0.95)"},
FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=
>} [Revenue])
or may be ignore selection in specific fields you are selecting in.