Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What do you mean by Value of Maximum Number of Hashtag?
=FirstSortedValue(Hashtag, -Aggr(COUNT(ID),Hashtag))
What do you mean by Value of Maximum Number of Hashtag?
=FirstSortedValue(Hashtag, -Aggr(COUNT(ID),Hashtag))