Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
deepak_km9886
Creator
Creator

How to get the value of maximum count from a column

I have 3000 records with 2 column Hashtag and ID,

I want to get the "value" of maximum number of hashtag in the column. I don't want the count of hashtags.

Simple Table values are like this:

Hashtag          ID

#a                    20

#a                    22

#g                    23

#h                    33

#h                    35

#h                    36

I should get the value "#h" Since it is having maximum count

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

What do you mean by Value of Maximum Number of Hashtag?

=FirstSortedValue(Hashtag, -Aggr(COUNT(ID),Hashtag))

View solution in original post

1 Reply
MK_QSL
MVP
MVP

What do you mean by Value of Maximum Number of Hashtag?

=FirstSortedValue(Hashtag, -Aggr(COUNT(ID),Hashtag))