Graphing the 5 most frequent items
What I am trying to achieve is to set up a horinzontal bar chart dynamically, so that the graph gets its values from the 5 most frequent items.
So the first question is whether this is feasable using FM.
If the answer is yes, then I have to figure out how to identify the 5 most frequent items.
So let's imagine that I have the Question table that keeps track of questions asked.
Question table fields:
- __kp_Question (number, auto-enter)
- QuestionSubject (text)
- TotalCountSubject (summary = count of QuestionSubject)
The Question::QuestionSubject field gets its values from the Subject value list with the following options:
Since I can't use a summary field to sort finds, I wonder what is the way to have listed the 5 most popular questions.