Do you mean you want the chart to summarize related records by a category? This is not really a charting issue; you will have the same problem if you want to show the individual summary values in the parent record.
The simple solution is to go to the child table and do the report/chart from there.
I have attempted doing the chart from the child table. The issue remains that the charting function seeks to compare one numeric field in a record to another numeric field. Or, across related records, sets of them. These charts would result from a set of values (Types of Assessments, for example) against a subsummary or a FoundCount, I believe.
So in more concrete terms, I'm looking at a set of Assessments that are related to Units with the Subject "Math." I want to do a pie chart of the distribution of Assessment Types in this set. My Assessments table has an AssessmentType field that is filled from a value list. It seems to me that FM has no way of making the pie chart—or any other chart for that matter—use a set of values as labels and a count of each occurrence of that value as the dependent variable in the chart.
My apologies if this is just obtuse on my part, but I am beginning to suspect that this might require a solution outside of FM.
I'm looking at a set of Assessments that are related to Units with the Subject "Math." I want to do a pie chart of the distribution of Assessment Types in this set.
Would this work for you?
SummarizeChild.fp7.zip 8.3 K
1 of 1 people found this helpful
It sounds like your chart needs to be showing the results of some calculations against the related records:
- Count ( List ( PatternCount ( Relation:targetfield ; text to count ) ) ) [top of my head -- check the functions carefully before using]
- with similar calcs for each text-field-result you want to track.
- Each should return the number or related records containing the target value, and you can plot those results in the graph.
You can build these calcs right into the graph setup rather than needing calc fields in the table(s).
I read through the Introduction to Charting Guide on the FileMaker site: http://help.filemaker.com/ci/fattach/get/21300/1268417531/redirect/1/session/L2F2LzEvdGltZS8xMzI5Mjk2MDU5L3NpZC9aZlBMUEtRaw==
Near the end, in the 'Charting Examples' section there is an example very similar to what you are trying to do....
I've attached the file I built using the guide as a reference... It is very similar to what Michael Horak posted...., though my chart oprens in a new window
Essentially, it depends on a summary field in the child table, and the chart being placed in a header or summary layout part, and the records being sorted by the data you want to summarise...
All the best,
display_chart.fp7.zip 7.4 K
These were all extremely helpful. Sky's solution looks like the most directly viable, but everything here definitely improved my skills with the charting and summaries. Thank you very much.