syzuhdi opened a new issue #4770: Cannot display Time Series Line Chart URL: https://github.com/apache/incubator-superset/issues/4770 Make sure these boxes are checked before submitting your issue - thank you! - [X] 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 0.22.1 ### Expected results Data shown in Time series Line Chart ### Actual results  When I click Run Query button in Slices, an error occur. Error u'CITY' Traceback (most recent call last): File "/usr/local/venv/lib/python2.7/site-packages/superset/viz.py", line 278, in get_payload data = self.get_data(df) File "/usr/local/venv/lib/python2.7/site-packages/superset/viz.py", line 1045, in get_data df = self.process_data(df) File "/usr/local/venv/lib/python2.7/site-packages/superset/viz.py", line 981, in process_data values=fd.get('metrics')) File "/usr/local/venv/lib/python2.7/site-packages/pandas/core/reshape/pivot.py", line 135, in pivot_table grouped = data.groupby(keys) File "/usr/local/venv/lib/python2.7/site-packages/pandas/core/generic.py", line 4416, in groupby **kwargs) File "/usr/local/venv/lib/python2.7/site-packages/pandas/core/groupby.py", line 1699, in groupby return klass(obj, by, **kwds) File "/usr/local/venv/lib/python2.7/site-packages/pandas/core/groupby.py", line 392, in __init__ mutated=self.mutated) File "/usr/local/venv/lib/python2.7/site-packages/pandas/core/groupby.py", line 2690, in _get_grouper raise KeyError(gpr) KeyError: u'CITY' And this is the QUERY SELECT "CITY", "__timestamp", "count_QTY" FROM (SELECT "CITY" AS "CITY", "REGN_DATE" AS "__timestamp", count(VIN_NO) AS "count_QTY" FROM (SELECT * FROM mycrm_registration) expr_qry JOIN (SELECT "CITY__", mme_inner__ FROM (SELECT "CITY" AS "CITY__", count(VIN_NO) AS mme_inner__ FROM (SELECT * FROM mycrm_registration) expr_qry WHERE "REGN_DATE" >= TO_TIMESTAMP('2018-03-30T00:00:00', 'YYYY-MM-DD"T"HH24:MI:SS.ff6') AND "REGN_DATE" <= TO_TIMESTAMP('2018-04-06T08:20:13', 'YYYY-MM-DD"T"HH24:MI:SS.ff6') GROUP BY "CITY" ORDER BY count(VIN_NO) DESC) WHERE ROWNUM <= 100) anon_1 ON "CITY" = "CITY__" WHERE "REGN_DATE" >= TO_TIMESTAMP('2018-03-30T00:00:00', 'YYYY-MM-DD"T"HH24:MI:SS.ff6') AND "REGN_DATE" <= TO_TIMESTAMP('2018-04-06T08:20:13', 'YYYY-MM-DD"T"HH24:MI:SS.ff6') GROUP BY "CITY", "REGN_DATE" ORDER BY count(VIN_NO) DESC) WHERE ROWNUM <= 50000 Any idea? ### Steps to reproduce
---------------------------------------------------------------- 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
