Chart record counts in found sets
Have had a look around the interwebs and havent been able to find a coherent answer to this.
I wish to create a chart. The data I want to chart is the ages of people in the database. I have a field which calculates age on the date of record creation and I want to chart this field, broken down into age groups i.e <1y, 1-5y, 5-10y and >10y.
Can anyone help with how to do this? I can do a find using the age criteria and then I get a number of records but I can't get these to show on a chart. Do I need to make the chart using a different table?