Display name of highest reslut

[#1]

Hi, I'm trying to return the name of the item at the top of the chart or the result with the highest number of hours.

So in this case the result the top Barrier based on the highest amount of down time associated with it would be "Noise"

I would like to return this result in a Text Box Object.

Thanks Rob

[swuehl · Accepted solution]

Try something like

=FirstSortedValue(Barrier, -aggr(sum( [Down Time]),Barrier))

assuming Barrier is the field name you are using as first dimension in above chart and sum([Down Time]) is the expression you are using.

Hope this helps,

Stefan

[#3]

That sorted it.

Thank you very much, this is what it was in the end.

=FirstSortedValue(Barriers, -aggr(sum(barriers_split_hrs),Barriers))

Cheers

Rob