Trying to display the most common option to a Text element from a dataset.
For example;
The Text element should display Monk, as it appears 2 times compared to the one that only appears once.
You can fetch the results from the DB and use the :group by operator
Group by the Tank Class text field and select the aggregation as Count
: Sort by the count, in descending and the :first item will be the most frequently occuring one
This is awesome, and definitely not something I would’ve thought of, however I can’t use the count in the sort. Unless I am doing something wrong here. See below.
Nevermind! Missed the count aggregate in the group. This works perfectly!
Awesome, no worries 
This topic was automatically closed after 70 days. New replies are no longer allowed.