show dimension for max value

[#1]

Hi,

I'm trying to show in a text object the field value for the corresponding max value of a calculation.

I'm calculating the total incoming values by TransactionHour, and want to show theTransactionHour that is the maximum.

I've tried variants of firstsortedvalue and max(aggr(sum())), but i can't seem to return theTransactionHour for the max value.

I know I've done this before, but maybe I've been staring at it too long

Richard

[swuehl · Accepted solution]

Try something like

=FirstSortedValue( TransactionHour, -aggr( sum(PC.IN), TransactionHour) )

[MarcoWedel]

Hi,

one solution could be:

hope this helps

regards

Marco

[#4]

Thanks,

That was it

=FirstSortedValue( TransactionHour, -aggr( sum(PC.IN), TransactionHour) )

It turns out that was one of the expressions I tried, but had inadvertently excluded the data source by filtering, so it was returning '-' and i thought my expression was wrong...Time to take a break!

[pratap6699]

=FirstSortedValue( TransactionHour, aggr( sum(PC.IN), TransactionHour) )-----it shows 1st fieldvalue means accesnding order 1st value

=FirstSortedValue( TransactionHour, -aggr( sum(PC.IN), TransactionHour) )-----it shows max fieldvalue means decesnding order 1st value

[#6]

Hi, how would make sure that this set analysis ignores all other TransactionHour selections?