Ordering the number of occurrences in a nested list and displaying in a repeating group

I’m building a review site and in the review process im recording keywords that can be selected form a list of options. They are stored in a review data type as a list.

I would like to display the most popular keywords selected by reviewers on the company profile page that they are reviewing but i’m having trouble doing this as i cant count the options that are in a number of nested lists.

For example, if a profile has 10 reviews, and across those reviews 5 of them have selected the “Benefits” keyword option and 3 of them have selected the “Sales Team”, I would like to show this in a repeating group ordered by count so 1. Benefits, 2. Sales Team.

Happy to use a plugin or backend workflow to achieve this. Please help!

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