Database Reference
In-Depth Information
draws the data exactly the way it appears in the fields, delimited data charts don't require a
sorted found set.
Figure 15-27. The mechanics of charting delimited data aren't all that different from a chart based
on records. The salient distinction is that the fields or calculations specified here must be a list of
values separated by returns.
Placing a Delimited data chart outside a Body layout part can result in some unexpected be-
havior. Generally speaking, the chart will show data from the currently active record. But
Delimited data charts inside Subsummary layout parts can show different results depending
on your found set and sort order. Bottom line: keep your Delimited data charts in the Body of
your layout.
Related Records
Much of FileMaker's data mojo comes from its relational database capabilities (
Chapter 5
),
and your charts can certainly tap into that. You can point a chart at a related table to graph
the values related to the record you're viewing, which opens up some interesting possibilit-
ies. Navigating from one record to the next means your chart will change to reflect the data
