[GitHub] jkokatjuhha commented on issue #3746: Time Grain Causes No Change in Bar Graph

[GitBox <gi...@apache.org>]

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 parameters are 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:
users@infra.apache.org


With regards,
Apache Git Services