I'm hoping that there's some method to present a chart such as this without having to specifically create a "zero" record for every date that has no value. Thanks!
You cannot chart data that you don't have. So even if you don't create a record for each missing date, you must provide the chart with a value for each X-axis point, and the Y-axis values need to correspond to the provided X-axis points.
And keep in mind that "dates" are just one form of "data" to FileMaker. It doesn't know that a date is missing from data just because the previous data is more than 1 (one) different from the next record. You will need to test either previous or next record via a calc to determine if something is missing and then decide how to deal with that.
Generally, data points represent records, so you are likely to need the dummy/zero record in the set for it to chart.
Stephen Huston wrote:
Generally, data points represent records
I wouldn't say that.
In any case, inserting dummy records into your "real" data table just for the purpose of charting seems like a very bad idea to me.
I didn't say it was a good idea. I also suggested handling the gaps if detected. This might be done with calculations, but adding calc fields to fill record gaps is even a heavier load on the table than dummy records, and it's harder to chart.
I am not suggesting there is a good way to chart missing data. Just pointing out that something must be added to the system if one insists on charting data that isn't already there.