jkokatjuhha commented on issue #3746: Time Grain Causes No Change in Bar Graph URL: https://github.com/apache/incubator-superset/issues/3746#issuecomment-344368246 Get the same error. Checked the SQL and it seems that the parameter for strftime is set incorrectly all the time. Weekly: ``` SELECT DATE(cancel_time, -strftime('%%w', cancel_time) || ' days') AS __timestamp, COUNT(ordernumber) AS count FROM canc_reasons WHERE cancel_time >= '2017-11-07 00:00:00.000000' AND cancel_time <= '2017-11-14 20:17:56.000000' GROUP BY DATE(cancel_time, -strftime('%%w', cancel_time) || ' days') ORDER BY count DESC LIMIT 50000 OFFSET 0 ``` Monthly: ``` SELECT DATE(cancel_time, -strftime('%%d', cancel_time) || ' days', '+1 day') AS __timestamp, COUNT(ordernumber) AS count FROM canc_reasons WHERE cancel_time >= '2017-11-07 00:00:00.000000' AND cancel_time <= '2017-11-14 20:20:18.000000' GROUP BY DATE(cancel_time, -strftime('%%d', cancel_time) || ' days', '+1 day') ORDER BY count DESC LIMIT 50000 OFFSET 0 ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on 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
