Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
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.
What is your dimension when you use this in the chart? May be try this
=Fractile(Aggr( $(=v_Delta) , Dimension/s), 0.33)
Lol sure, but this chart does, does it not?
Same thing with AGGR-wrapping, shows only "-" as is its not valid expression
Would you be able to share a sample to check this out?
Here you go.
Please use date filter..
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?
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 ?
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.