It's all possible, but how is your table structured? and what kind of chart? Will this be a chart of all the records in a found set (all the records pulled up by performing a find)?
I have a patient's table that contains records of individual patients. Both of the fields that I would like to chart (column graph or stacked bar) gender and ethnicity are fields in this table. It would be great to chart just the found set.
Name Gender Race/Ethnicity
Jane Doe Female Caucasian
John Smith Male Caucasian
Jose Perez Male Hispanic
The other tables are not useful for this task (contact tracking, inventory items)
For a simple barchart, what you chart for your Y-axis data series is actually a summary field with the "count of" setting set to count some field in the table that is never empty of data for any of the records being counted. In your data source settings, you'd specify grouped records. The trick is to be able to group your records into gender/ethnicity groups by sorting on a single field. This requires a calculation field such as:
Left ( Gender ; 1 ) & Ethnicity
To combine the two values in a single field.
For stacked bar charts you need Four fields, one pair to count male patients and one to count female:
cMaleFlag: Gender = "Male"
cFemaleFlag: Gender = "Female"
Then you set up and chart two summary fields, one to compute the total of cMaleFlag and one to compute the total of cFemaleFlag. And you'd just sort your records by Ethnicity. And you'd have two y-axis data series: one for each summary field.
Worked Perfectly, thank you!