AnsweredAssumed Answered

List of top number of occurrences in a portal?

Question asked by tkessler45 on Aug 4, 2016
Latest reply on Aug 4, 2016 by PeterDoern

This has been somewhat challenging for me. I have a portal who's entries include a text field of item categories, for instance colors such as Red, Blue, Green, Cyan, Orange, Brown, Yellow, etc. The portal's contents will dynamically change based on various conditions, but for any condition I need to get a list of the top three categories that exist in the portal. So for instance, with the following data I would need an output of Red,Green,Yellow in that order, seeing that there are four Red, three Green, and two Yellow:

 

Green

Blue

Green

Red

Brown

Red

Red

Orange

Green

Yellow

Red

Yellow

 

The conditions are that the list of items would need to be limited to the top 3, that it displays the items in order, and that the items all come from a field in a portal.

Outcomes