AnsweredAssumed Answered

Creating Charts from Multiple Fields Using Summary Count Totals

Question asked by AlanJames on Apr 19, 2013
Latest reply on Apr 25, 2013 by philmodjunk

Title

Creating Charts from Multiple Fields Using Summary Count Totals

Post

     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.

Outcomes