Complex variable as Fractile source (chart function)

[FinEst]

Hello how are you,

I made statistical variable "v_Delta" as :

SUM(XX) - (LinEst_M(total XX, YY) * SUM(YY) + LinEst_B(total XX, YY))

If I try to use it on KPI as:

=Fractile($(=v_Delta), 0.33)

It fails and shows no value.

V_Delta shows correct amounts if used in table chart, so that's not the problem:

Also in expression editors variable shows value:

Any ideas???

[sunny_talwar]

What is your dimension when you use this in the chart? May be try this

=Fractile(Aggr(
    $(=v_Delta)
, Dimension/s), 0.33)

[FinEst]

KPI has no dimensions only measures

[sunny_talwar]

Lol sure, but this chart does, does it not?

[FinEst]

Same thing with AGGR-wrapping, shows only "-" as is its not valid expression

[sunny_talwar]

Would you be able to share a sample to check this out?

[FinEst]

Here you go.

Please use date filter..

[sunny_talwar]

So, if I don't filter on anything and use this expression

Fractile(Aggr($(v_Delta), D), 0.33)

I get this

But you mentioned to filter on date, if I do that, then even the value within the chart goes away

Would you be able to point out what exactly are you hoping to get from the sample attached? Is it based on selection in Date? What is the expected output within KPI when you select 25.11.2018?

[FinEst]

As you can see, every date (D) has incorrect calculation on fractile, it is just the v_delta, but total fractile is correct.

Why the v_Delta fails calculating with one D selection ?

[FinEst · Accepted solution]

I added granularity for the D filter in this qvf.

It seems that Fractile-function AND linest_m with total parameter need array of values to compute correctly.