1 of 1 people found this helpful
Well, strictly speaking, the average is just a single datum derived from the multiple data points of the first series ...
So, how do you generate the first y-series, and the average?
How are you calculating the average?
I would expect the line that you want if you used a summary field to compute the average. Putting the average into a global field might also work.
Figured it out. I was doing a SQL with "AVG", but that was only a single point. I wasn't sure, given that I was selecting dates for the first series, if FMP would just draw the line across that same date range, but it doesn't.
The solution as you've suggested many times for other things, Phil, was to create a calculated field for average and use that in the SELECT for the second series and not AVG itself.
Thanks to all....problem fixed.
(erolst's answer was also correct and really got me thinking, but I don't see how to give correct answers to multiple responses from different people.)
Your answer got me thinking and I ultimately figured it out.