Date based on Max Count

[#1]

Hi all,

I want to show the date(s) with the largest amount of visitors in a text object.

Example:

Date:               Visitor:

01-04-2017          John

01-04-2017          Paul

01-04-2017          Ronald

02-04-2017          Donald

03-04-2017          John

03-04-2017          Paul

So, I expect to see a result 01-04-2017 in my text object. Even more, if multiple days have the largest amount of visitors I want to see all dates.

Thank you in advance

[Anil_Babu_Samineni]

May be this

FirstSortedValue(Date, -Aggr(Count(Date),Date))

[Anonymous · Accepted solution]

=concat ( IF( aggr ( Rank(count(1)),Date)=1, Date & chr(10)))... You can use any seperator instead of Chr(10)

[#4]

Thanks, this works!!

[#5]

Thank you, this works if there is only one busiest day. Thanks you for your time.