What do you want to show on the graph if there were two appointments in the same month?
Creating "dummy dates" for the in between months and interpolating the Y-Axis data--which then usually assumes a straight line Y = mX + B curve between points is the only way to do this with just FileMaker's native Chart Object. You might also explore any current charting plug ins or using Java Script in a web viewer as alternative approaches that might not require this kind of "fudging" to get a meaningful chart.
Thanks for the lightning fast answer Phil
Sometimes, people may get a relapse (that will correspond to a scale score spike) and after 1-2 weeks there will be recovery (meaning that scores will be reduce). So the chart could be used to show this activity within a month.
So basically, the dummy table is the only viable option within FM for something like this if i understand correctly.
I don't see how you can show that "Spike" if you are only plotting against a monthly scale. You could show the Max, the Min or the Average of this value from the two appointments, but you are only going to see one point on the chart.
And I described two other viable options besides dummy data used to get the x-axis correct. Both would be "within FM" but would use tools other than the built in Charting Object.
thanks gain Phil.
I 'll look into the options mentioned.