AnsweredAssumed Answered

Charting by Counting Fields of Value List

Question asked by q8khajah on Mar 18, 2014
Latest reply on Mar 19, 2014 by philmodjunk


Charting by Counting Fields of Value List


     Good Day everyone,

     I am trying to create a chart where the counts of Text values of a value list is plotted.

     For example, I have employees from different departments ,, lets say FIELD: DEPARTMENT can be either "Group A" , "Group B", or "Group C" for each record.

     I would like to be able to plot a chart counting employees of each department.

     I know it sounds simple, and the way I was going around it is by using calculations with an IF function that aggregates other fields counting up. 

     I simply would like to know if there is a better way on going about that please?

     Plus, when it comes to charting, I am abit lost on how to use custom fields rather than use summary fields for plotting in the chart wizard.

     Would appreciate any pointers.