SHOW AVG IN SUM CHART REPORT? 1

[floydpepper]

Ladies and Gents,
I have a line chart report that tracks the count of events that occur each day (3 separate reports for one week/month/and 6 months). Is there a way to have this report display a second "trend" line that would maintain the avg of these counts? Thanks in advance for your help.

FloydP

 

[GingerR]

Have you tried the Trend Line feature? If not--go into the design of your report. Double-click on the chart. Choose the line. From the toolbar, choose Chart - Add Trendline. There are many options from there. Sounds like 'moving average' might be what you want.

Hope this helps.