Is it possible to sort by count in appsheet. I have a view where it shows tickets grouped by store and category but I wanted to sort it by the highest number of tickets by category when a store is selected. Then after selecting a category I wanted to sort it by the newest date at top.
I have this formula below in a VC with text type but it only gives me the count and not the actual label
COUNT(select(tICKETTYPE[l2], [L2] =[_THISROW].[L2], TRUE))