FirstSortedValue and Count

[#1]

Good day all

I am stuck!

What I wish to achieve is to return the date which is associated to the most number of orders for a day. Is firstsortedvalue the correct way to go? I have attached my app as well as a screenshot which adds more detail to my question:

Many thanks

Scott

[#2]

Do you really want the date or just order the date by the Count?

[jolivares]

Try this:

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

[sunny_talwar]

For the second part of the question, try this -> =FirstSortedValue(Date,-(Aggr(Count(OrderNo),Date)* 100000+Date))

[swuehl]

Part 2: Add a small value depending on date to distinguish between same Count:

=FirstSortedValue(Date,-Aggr(Count(OrderNo)+Date/1E6,Date))

[#6]

=only({<Date = {"=count(OrderNo)=Max(TOtal aggr(count(OrderNo),Date))"}>}Date) in a TextBox gives you exaktly the 15/01/2016

[#7]

Does not seem to work for some reason when I copied this expression

[#8]

I require the date.

[#9]

my qvw: