FirstSortedValue Aggr double values

[Anonymous]

Hi,

I want to create a textbox in which I want to display the name of the individual whose name occurs most often. To do this I use below expression in which 'name' is the column in which the name of the individual is displayed:

FirstSortedValue(name, -Aggr(count([name]), name))

This generates what I am looking for but as soon as there are multiple names with the same max count, the textbox goes empty, indicating that something goes wrong. Any idea how to fix this?

[Anonymous]

Ok cool, the only I don't understand yet is the '1E10' component. What does it do?

[sunny_talwar]

1E10 equals 10000000000... I am dividing the TimeStamp by this number because I want TimeStamp to be used second when determining the sort order. For example, if you count is like this and timestamp in its numerical form is this

Name     Count     TimeStamp

Stijn          10          42000

Sunny          8          42150

xyz             10          41999

You will see Sunny as the top one, where as the top Name should be Stijn. So Count + TimeStamp/1E10

[Anonymous]

Got it, thank you very much!