AnsweredAssumed Answered

Graphing the 5 most frequent items

Question asked by NaturSalus on Nov 21, 2013
Latest reply on Nov 23, 2013 by philmodjunk

Title

Graphing the 5 most frequent items

Post

     Hello,

     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:

         
  •           Product
  •      
  •           Service
  •      
  •           Cost
  •      
  •           Payment
  •      
  •           Delivery
  •      
  •           Refunds
  •      
  •           Support
  •      
  •           etc

      

      

     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.

      

     Thanks

      

Outcomes