truyet opened a new issue #4213: Visualize from sql editor auto add % URL: https://github.com/apache/incubator-superset/issues/4213 Make sure these boxes are checked before submitting your issue - thank you! - [ *] I have checked the superset logs for python stacktraces and included it here as text if any - [ *] I have reproduced the issue with at least the latest released version of superset - [ *] I have checked the issue tracker for the same issue and I haven't found one similar ### Superset version 0.22.1 I have a query parse value of date to week number.  But after I visualize query to build pivot table, query become: SELECT pmcid AS pmcid, ymd AS ymd, sum(trans) AS sum__trans FROM (SELECT ymddate, pmcid, CONCAT('W', WEEK(STR_TO_DATE(ymd, **'%%%%Y%%%%m%%%%d'**))) AS ymd, trans FROM weekly_zlp_volumn2017 LIMIT 100) AS expr_qry WHERE ymddate >= STR_TO_DATE('2017-01-15 00:00:00', '%%Y-%%m-%%d %%H:%%i:%%s') AND ymddate <= STR_TO_DATE('2018-01-15 13:50:29', '%%Y-%%m-%%d %%H:%%i:%%s') GROUP BY pmcid, ymd ORDER BY sum__trans DESC LIMIT 50000 column ymd return null because it wrong date format
---------------------------------------------------------------- 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
