Creating Charts from Multiple Fields Using Summary Count Totals
I am trying to create a chart that displays data from several fields over a large found set, but displays only one bar per field it is displaying.
Easiest done by simple example:
- I have 20 people all of whom can own a red, blue or a green hat. They can own more than one hat.
13 people own a red hat
a different 12 people own a blue hat
and 5 people own green hat
In my database I can easily create a Count Summary field that contains the numbers 13, 12 and 5 when I find the full set of 20 people, or even the appropriate set when I find fewer records.
My problem is, how do I get Filemaker 12 to display this Count Summary data in a bar chart.
Apologies if this has been asked before but I couldn't find it on search.