I have multiple fields in one record where we enter data points that came from a line graph. Can I chart this in Filemaker 15 or 16? See attached snapshot.
Thanks in advance.
A chart needs a list, so if you can generate the list, you can get the points on the chart.
If column one is many fields in one record, you could do this:
The problem is that List will skip over empty values.
So you'd have to manually make the list:
<<Field1>> & "¶" &<<Field2>> & "¶" & . ..
For one column, that is one Data Series in the chart set up.
You can add other series with a different set of fields.
Be sure to set up the chart to show "CurrentRecord(delimited data)" in the Source Tab (see the post above)
Ideally, though, these fields are actually many child records, and you can then pull them using other methods. But if you can't change your data structure, follow the idea above.
Hi Jeremy. Thanks for the tip. It does work with the list. Thank you.
When there's a blank, I have to modify the list to match both columns. I will also look into changing the database structure to have another table.
Retrieving data ...