Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
I have a table like this one:
Layers:
Load*Inline [
Layer, Amount
L1, 3
L2, 12
L3, 6
];
I have a KPI object to show Max(Layer) value. And I want to show as a label for this expression for which layer name this expression is related. Now it will be L2, but the next reload it may be the other one. So I need some dynamic in the label name.
Can someone tell how to create dynamic label?
try this as title expression
=FirstSortedValue(Layer,-aggr(Max(Amount),Layer))
try this as title expression
=FirstSortedValue(Layer,-aggr(Max(Amount),Layer))
Thank you for help. It works.
Can you, please, explain why there is a minus before Aggr?
Aggr creates a virtual table and if you dont have minus the layer with least will be returned by first sorted value.
Understood. Thank you👍!