Add an 'Average' line to line chart

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: