Chart Display - Daily Totals + Moving Average

Ignition
2

So I’ve got a solution. I have two custom properties on my chart:

1 - DailyTotals (dataset)
2 - MovingAvg (dataset)

DailyTotals is bound to my first query in my original post.

MovingAve is bound to this query:

SELECT Week_Day, AVG(Quantity)  OVER (ORDER BY Week_Day rows unbounded preceding) 
  FROM (
     SELECT Day(t_stamp) [Week_Day], SUM(Quantity) [Quantity]
     FROM Widget_Tracking
    WHERE Month(t_stamp) = 5 AND (SELECT DATEPART(yy, GETDATE())) = YEAR(t_stamp) AND Machine_Number = 
    2
GROUP BY Month(t_stamp), DAY(t_stamp))
AS SUBQUERY

I haven’t queried a result set from another query before, that was the missing link. If you have other suggestions I’d listen!

1 Like