Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Here is my issue: I need to calculate value after fractile value.
Foe example for Category1 fractile value is 4.32 and value after it is 5, that is the one I would like to show to the user
This function does not work
=Min(If Value>Fractile(Value,0.83),Value)
Any suggestions?
Data:
LOAD * INLINE [
Category, Value
Category1, 1
Category1, 2
Category1, 3
Category1, 4
Category1, 5
Category2, 1
Category2, 1
Category2, 3
Category2, 4
Category2, 11
];
Fractile( aggr(avg(sales), somefield),0.83)
=fractile(If([value]>( [value]),0.83)
May be this:
=Min(If(Value>Fractile(TOTAL Value,0.83),Value))
No, it does not work
=Min(If(Value>Fractile(TOTAL Value,0.83),Value))
this calculates it for all records
Fractile(TOTAL Value,0.83)
I am not sure what else you are looking for? Can you elaborate on the result you are looking for?
Try
=Min(Aggr(If (Value>Fractile(TOTAL<Category> Value,0.83),Value),Category,Value))