Example: Charting delimited data
FileMaker Pro can chart multiple data entries from a single field when each data value in the field is separated by a carriage-return character (carriage return-delimited data).
About the chart
In this example, you create a new database containing two return-delimited fields: Country and Customer Count. The fields are located on one layout and all data is stored in one record. Then you create a column chart that compares the number of customers located in each country.
Create a database
1.
 •
If the FileMaker Quick Start Screen is open, click Create a New Database, then close the Quick Start Screen.
 •
2.
Name the file Worldwide Customers, then click Save to save the file on your hard disk.
The file opens in Browse mode in Table View. FileMaker Pro creates the first table and layout for you. Both have the same name as the file.
Define and format the fields
1.
In the first table row, click Create Field and type Country.
2.
Click + in the column and type Customer Count.
3.
Click View As Form View in the layout bar to go to Form View, then click Edit Layout to switch to Layout mode.
4.
Select the Customer Count field and field label and drag them down about an inch.
5.
Select the Country field and drag its handles down until you see 5 rows in the field.
6.
Select the Customer Count field and drag its handles down until you see 5 rows in the field.
7.
Click Save Layout, then Exit Layout in the layout bar to return to Browse mode.
Add data to the database
1.
Click New Record in the status toolbar.
2.
In the Country field, type the following, pressing Enter (Windows) or Return (OS X) after each country name.
Spain
Italy
Japan
Germany
USA
3.
In the Customer Count field, type the following, pressing Enter (Windows) or Return (OS X) after each value.
15
6
23
10
29
You have created two fields that contain return-delimited data.
Create a column to compare the number of customers in each country
1.
Click Edit Layout in the layout bar to switch to Layout mode.
2.
3.
Click the Chart tool Chart tool in the status toolbar, then click in the body layout part and drag a large rectangle where you want the chart to appear.
The Chart Setup dialog box appears.
4.
In the Chart inspector, click Data Source and choose Current Record (delimited data).
5.
In the Chart area of the Chart inspector, enter the following:
 
Type Customers by Country.
Choose Column.
For Title, type Countries.
For Data, click Specify button, choose Specify Field Name, choose Country in the list, then click OK.
For Title, type Number of Customers.
For Data, click Specify button, choose Specify Field Name, choose Customer Count in the list, then click OK.
6.
Click Done.
7.
Click Save Layout, then Exit Layout in the layout bar.
Each return-delimited value in the Country field corresponds to a return-delimited value in the Member Count field in the order the data was entered.