AnsweredAssumed Answered

Chart how-to: Count of factor 1 vs. factor 2?

Question asked by JimMiller_2 on Mar 23, 2015
Latest reply on Mar 24, 2015 by JimMiller_2

Title

Chart how-to: Count of factor 1 vs. factor 2?

Post

I'm new to Filemaker, and am still trying to figure out how its charting system works.  I've got a database that contains, among other things, columns for "age" and "household income".  Each row has a value for these columns, like so:

         
  • Age: One of "18-24", "25-34", "35-50", and so on.
  •      
  • Household income: One of "less than $25,000", "$25,000 - $35,000", and so on.

I'm trying to get a graph containing sets of columns that show the number of people in each cell of the table, if you will:

         
  • For age = 18-24, the numbers of people in each of the income groups
  •      
  • For age = 25-34, the numbers of people in each of the income groups,
  •      
  • and so on

Pretty straightforward, but I just can't figure it out.  I'm guessing it has something to do with creating leading or trailing groups, but, again, I'm just not there.  Can anybody offer some advice?  Thanks!

Outcomes