How to return most common Stringvalue

[pschwegler003]

Hi all,

I would like to make a chartfunction which returns the stringvalue of the most common stringvalue in data.

I have a column in data containing the following fields (distinct):

BE (8 times)

DE (5 times)

So I wish return stringvalue:  "BE" which I would like to use further as a variable.

When above is not clear enough, let me know.

Thanks in advance!

Pascal

[sunny_talwar]

May be this

FirstSortedValue(StringValue, -Aggr(Count(StringValue), StringValue))