vschoener opened a new issue #3209: Extra % added in SQL Lab during visualisation URL: https://github.com/apache/incubator-superset/issues/3209 Make sure these boxes are checked before submitting your issue - thank you! - [No required] I have checked the superset logs for python stacktraces and included it here as text if any - [x] I have reproduced the issue with at least the latest released version of superset - [x] I have checked the issue tracker for the same issue and I haven't found one similar ### Superset version {"GIT_SHA": "", "version": "0.18.5"} ### Expected results A list grouped by time (hourly) and type (24 columns, with 2 type, breakdown to display them ### Actual results It works well when I edit my query, then when I visualize, the result is not right. Only 2 column instead of 24 ### Steps to reproduce Here is my SQL query: SELECT count(*) as 'total_activities', type, hour(`datetime`) as hourly FROM activity GROUP BY `type`, DATE_FORMAT(`datetime`, "H:00:00") ORDER BY `datetime` ASC; -------------- The visualised query looks like : SELECT hourly AS hourly, type AS type, sum(total_activities) AS sum__total_activities FROM (SELECT count(*) as 'total_activities', type, hour(`datetime`) as hourly FROM activity GROUP BY `type`, DATE_FORMAT(`datetime`, "%%%%H:00:00") ORDER BY `datetime` ASC) AS expr_qry GROUP BY hourly, type ORDER BY sum__total_activities DESC LIMIT 50000 As you see, it adds 2 extra "%%" in the DATE_FORMAT, so the result for hourly will return only "0" instead of the 12 or 24 hours (depending of the format needed) Is this normal ? Or did I miss something ? Maybe better way to display ma data by hour for a 24 hour grouped with type of activity ? Thanks ---------------------------------------------------------------- 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
