Get Top N results in a count(*) group by XX query, using the UI

rfernandez

Hi,

I need to display the total register count grouped by one column of a relation, but only for the top 10 records.
How do I do that?

I can set the max number of results to 10. Fine.
Then I tried ordering the results descending, however I can only order by the existing fields, not the count itself
I'm using only 2 columns, making a count in one and grouping by the other.

Thank you !

gabriel

You are right, aggregated columns are not available to sort with. I don´t think this is easily doable with the current feature set, without generating this data and storing the result somewhere for later display.

It´s not something I´ve needed personally, but I can see the use case.

rfernandez

Ok. I'll try to do that pre-building of the info and then retrieving it.
Thank you!