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: