4 Replies Latest reply on Jan 15, 2017 8:27 AM by fmpdude

# Graphing an average as a line?

I have a y-series in an FM line chart. Works fine, shows lots of variability.

I also added another y-series for the same date range, which is an average of the initial y-series data. I was hoping/expecting to see a line for the average go across the chart so the user could see the average that way.

However, what I get instead with the second average y-series is just a single point way over on the left side.

So my question: Is there a way to get the second y-series, the average of the first y-series, to give me a line instead of just a point?

• ###### 1. Re: Graphing an average as a line?

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?

1 of 1 people found this helpful
• ###### 2. Re: Graphing an average as a line?

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?

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.)