return the most frequent asset

[samuel_brierley]

Hi all,

I have a table like the one below that counts the number of times an asset appears and then sorts highest to lowest.

I have a formula that goes in a text box =Max ( aggr ( count ( Equipment_Id ),Equipment_Id  ) ) that returns the 699 as you would expect. what im after is to return the actual Equipment ID.

thanks all

[Kushal_Chawda · Accepted solution]

Try,

Firstsortedvalue( Equipment_Id, -aggr ( count ( Equipment_Id ),Equipment_Id  ))

[samuel_brierley]

Thanks for the quick reply, I thought it would be something like that however couldn't quite figure the syntax.

[maxgro]

it seems the formula works

[Kushal_Chawda]

I had modified the syntax

Firstsortedvalue( Equipment_Id, -aggr ( count ( Equipment_Id ),Equipment_Id  ))