Add 15 day rolling average line to graph

  • Thread starter Thread starter Timothy.Rybak
  • Start date Start date
T

Timothy.Rybak

I have a graph report that has a single line that represents the total
number of parts produced in a given day. Every day the quantity varies
and the graph shows each day as a separate point. In Excel, I can
simply set up a formula that averages the previous 15 days worth of
data and enter that in a column to graph.How would I do this in Access?

I am looking for a graph with two lines... one is the actual data, and
one would have a point for every day, but that point would be an
average of the past 15 days worth of data.

Thanks!
Tim
 
Consider changing your Row Source to something like:
SELECT ProductionDate, ProductionQty,
(SELECT Avg(ProductionQty)
FROM qtotGraph T2
WHERE T2.ProductionDate Between T1.ProductionDate and T1.ProductionDate -
15) AS MovAvg
FROM qtotGraph T1;
 
Back
Top