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?

Thanks in advance.

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.