Sort RG based on # of duplicates

Hey everyone!

I have an RG that i’m attempting to sort w/ no luck. Hopefully someone has a good idea of how to accomplish what I want.

The RG does a search for lists of things in my database and shows all unique elements. I would like it to sort by having items with the most occurrences at the top. I can do a text box that shows the #, but i can’t reference that box in sort. Any ideas? :slight_smile:

@andyestridge One approach might be 'do a search on thing:grouped by field with aggregation on count:sorted by count descending.

3 Likes

oh heck yes! That’s PERFECT.

Thanks!

This topic was automatically closed after 70 days. New replies are no longer allowed.