AnsweredAssumed Answered

[Newbie] Charting Q.  Charting quantities of occurences of a specific field in a table

Question asked by lelandv on May 27, 2014
Latest reply on May 28, 2014 by lelandv

Title

[Newbie] Charting Q.  Charting quantities of occurences of a specific field in a table

Post

     Hi All, 

     I apologise in advance for the newbie question.  I'm looking for a way of charting the number of occurrences of each of the values in a given field in a table.

     In practical terms, I have a table of "people", and in that table there is a field representing the person's "grade" or "level".  The value of this can be either undefined or anything from 0 to 10.

     I want to create a chart that shows for each unique value in the table for that field, how many rows (people) there are with that value set.

     I was looking at potentially doing this with an ExecuteSQL but that only gives me half of the data that I need.

     Is there a relatively easy way to do this ?

      

     Thanks in advance !

      

     Leland

      

      

Outcomes