Line Chart – FileMakerHacks

Chart, Level: Advanced, Version: FM 11 or later

Array Charting, part 2

July 14, 2011August 24, 2022 Kevin Frank

Last week we looked at building a FileMaker 11 native chart based on data that has been parsed into a field-based array.

2011-07-11-b

I happen to like field-based arrays, for reasons I’ll get to in a minute, but is a field-based array really necessary to generate the above chart? Continue reading “Array Charting, part 2” →

Chart, Level: Intermediate, Version: FM 11 or later

Array Charting, part 1

July 3, 2011August 24, 2022 Kevin Frank

In recent postings we’ve looked at…

Using a lookup to populate or clear an array (Lookups and Repeaters)
Determining the position of an item in a list (ValuePosition)
Parsing subsummary values from a found set (Fast Summaries)

While these three techniques may not appear to have much in common, all of them are used as building blocks in today’s demo, line-chart-from-field-array. Our data set is a table of web site visits, by week and by state, beginning in March 2006 and running through June 2011.

Wouldn’t it be nice to to use FileMaker 11’s built-in charting capabilities to produce a line chart showing weekly visits per year? Continue reading “Array Charting, part 1” →