
1. Re: Graphing an average as a line?
erolst Jan 15, 2017 4:19 AM (in response to fmpdude)1 of 1 people found this helpfulWell, 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 yseries, and the average?

2. Re: Graphing an average as a line?
philmodjunk Jan 15, 2017 8:12 AM (in response to fmpdude)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.

3. Re: Graphing an average as a line?
fmpdude Jan 15, 2017 8:27 AM (in response to fmpdude)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.)

4. Re: Graphing an average as a line?
fmpdude Jan 15, 2017 8:27 AM (in response to erolst)Your answer got me thinking and I ultimately figured it out.
Thanks E.