Is there anyway to use the 'limit' in the question editor per field top in order to get the top Dim2 for each Dim 1 as per the image below without using a custom query?
Hi @robert.mifsud.bonnic
You can use Max of dim2, Sum of count - grouped by dim1 - example:
Unfortunately that is not what I am looking for. I would like the value of Dim2 where the count is the highest. The solution provided gives the max Dim2 alphabetically.
@robert.mifsud.bonnic You would either have to create multiple sub-queries or use SQL.