I can't figure why there is a difference between a line chart that works fine in FileMaker Pro, but has a defect in FileMaker Go. Here is a description of the problem, with a simple illustration.
The data table has 31 records in it, one for each day of the month. In one field, the values are inserted for all 31 records using a calculation that determines the even distribution of values between the first and last record. The second field is empty, intended for user input into one record each day of the month.
The chart plots two series of points as lines. The first series shows a straight line path representing a goal for a month. Let's say, for example, you want to show daily progress toward a goal of reducing accidents. The straight line path plots the goal from start to finish. Then, the second plotted line shows the daily progress as a new value is entered into the daily records.
In FileMaker Pro, the line graph looks fine, but in FileMaker Go, the empty values in the second field are assumed to be zero, resulting in an almost vertical line being drawn from the last entered value to the baseline of the chart.
Is this a known (or unknown) defect in FileMaker Go? Or is there a better way to define the chart format, such as using a single field with a calculation of the points as delimited values in a single field?
thanks for any input .... please refer to the simple illustration I made to help you understand the issue.
Message was edited by: dburnham added illustration