Maximum times repeated output in text object

[#1]

Hi,

i have 3 companies and i want the URL which has been repeated the most to be displayed in the text box below it.

Your assistance on this would be appreciated.

[jerem1234]

Used this expression:

=firstsortedvalue([Most viewed_1],-aggr(count([Most viewed_1]), [Most viewed_1]))

Please find attached.

[jerem1234 · Accepted solution]

Even better, you may want to use:

=firstsortedvalue(distinct [Most viewed_1],-aggr(count([Most viewed_1]), [Most viewed_1]))

to handle ties (since if they are more than one link that has the highest, firstsortedvalue without the distinct will return null.

Hope this helps!

[#4]

Thanks Jerem...

[#5]

When i am trying on the actual dashboard where instead of list box i have to show the same result just infront of each company shown in an adjacent text box, the result is not coming....Can you please check what i am missing...

thanks  aton

[jerem1234]

Looking at your field [Most viewed_1], you have no values for any of the rows. This is why they are coming back as null.

[#7]

thanks..i figured out the problem.....