I have 5 tables (a table for each of 5 companies), that I want to use to plot specific financial data for all 5 companies on one plot (i.e. Inventory Turns etc.) in column and/or line charts by year.The problem is the data in the charts have holes in them and the data series don't all start and stop with the same year.
I am assuming I need a temp table for each of the five tables that have a common year range to all of the company tables and where there are holes enter a 0. I would then use the list function with the delimited data source in the chart. Is this the simplest approach? I can't seem to figure out how to place the data in the correct "cell" once I create temp records and enter the year range. The range of years is only going to be 5 or 6 years. I've looked at the Array Chart articles from Filemaker Hacks, but it seems a little more than I need and can't seem to get started with it?