Missing dynamic Date charts
I have following sql for displaying no of orders each day in chart.
SELECT CONCAT(LEFT(MONTHNAME(OrderDate), 3), ' ', DAY(OrderDate), ',', YEAR(OrderDate)) AS XLABEL, SUM(OrderTotal) AS YVALUE FROM orders GROUP BY CONCAT(LEFT(MONTHNAME(OrderDate), 3), ' ', DAY(OrderDate), ',', YEAR(OrderDate)), DAYOFWEEK(OrderDate) ORDER BY DATE(OrderDate) ASC
It works completely fine. But if 1 day order was not placed then graph doesn't go down but continue to next date.