I have a line chart that works great …
What I want to do is add a second line for the average. I know I must do that in my query but can’t figure out the proper syntax. Here is my Query …
SELECT
	joborders.JODateRec AS Work_Date,
	COUNT( joborders.JODateRec ) AS Job_Orders
FROM
	joborders 
WHERE
	joborders.JODateRec >= NOW() - INTERVAL 28 DAY 
GROUP BY
	joborders.JODateRec 
ORDER BY
	joborders.JODateRec
      
        Community Page
Last updated:
    Last updated:
