dpugulo edited a comment on issue #9308: Time Series Bar Chart(monthly) with 1 year time shift URL: https://github.com/apache/incubator-superset/issues/9308#issuecomment-609481643 same problem, my time filter 2019-10-01 => 2020-03-31 Could it be from my mysql or language settings? or February 29 is that why? This chart; 365 day shift  This chart; 1 year shift  This chart; 12 month shift  my query; SELECT DATE(DATE_SUB(issue_date, INTERVAL DAYOFMONTH(issue_date) - 1 DAY)) AS __timestamp, sum(total_price) AS `Toplam` FROM blabla WHERE issue_date >= STR_TO_DATE('2019-10-01 00:00:00.000000', '%Y-%m-%d %H:%i:%s.%f') AND issue_date <= STR_TO_DATE('2020-03-31 00:00:00.000000', '%Y-%m-%d %H:%i:%s.%f') AND is_deleted = 0 AND status IN (3, 4) GROUP BY DATE(DATE_SUB(issue_date, INTERVAL DAYOFMONTH(issue_date) - 1 DAY)) ORDER BY `Toplam` DESC LIMIT 10000; ----------------------------- I am waiting for your feedback and solution suggestions, thank you
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
