Finding the max value of a column

[Anonymous]

I have One column Age in my excel.

<18

18 to 24

25 to 34

35 to 44

45 to 59

and i want to know about the maximum occurrence of Age.

Lets Say 

< 18 : 2

18 to 24: 4

25 to 34: 1

35 to 44 : 3

45 to 59: 8

60+ :

So i want to know to get the max value out of Age... Like in this case the answer will be 8 corresponding to 45 to 59 age group...

So just by writing max(Age) its giving me 60+ which acc to logic is fine. But what if I want the function to consider the corresponding values and bring out the max in them

[Anil_Babu_Samineni]

You are getting values like 2, 4, 1, 3, 8. You have to provide this for Max like Max(Expression for those values)

[Anonymous]

something like Max(aggr(Max(age),yourfield))??

[Kushal_Chawda]

can you please share the sample data with expected output?

[annafuksa1]

you need to create chart with age brackets as dimension and use function max as expression

[Anonymous]

I need an Text object expression which gives me the output like:

Insights: Maximum No.  is 8 and its fall in Age Category: "45 to 59"

[Anil_Babu_Samineni · Accepted solution]

May be use this?

='Maximum no is  ' & Count({<Age = {'$(=FirstSortedValue(Age, -Aggr(Count(Name),Age)))'}>} Name)  & ' and it falls in Age Category '  & FirstSortedValue(Age, -Aggr(Count(Name),Age))

[Anonymous]

Thank you very much Anil. You save my day

[Anil_Babu_Samineni]

I am glad i was able to help you

[Kushal_Chawda]

you can optimize your expression of maximum number expression as below. Age category expression is fine as what suggested by Anil

=FirstSortedValue(aggr(Count(Age),Age),-aggr(Count(Age),Age))