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.