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?
Solved! Go to Solution.
Earlier you were looking for firstsortedvalue (in descending order) based on just the count(Name), I added a little portion of Timestamp by adding Max(Timestamp)/1E10 to determine the sort order