I am facing the same issue but with BigQuery as our database engine.
Both with and without a time grain I get a yellow warning message stating:
`'SUM(pings)'`. The table visualisation works fine but never the line chart.
Here's the query it generates:
```sql
SELECT TIMESTAMP_TRUNC(created, DAY) AS `__timestamp`,
SUM(`pings`) AS `SUM_pings_`
FROM `table`
WHERE `created` >= '2018-08-14 00:00:00'
AND `created` <= '2018-09-11 13:30:56'
GROUP BY `__timestamp`
ORDER BY `SUM_pings_` DESC
LIMIT 5000;
```
[ Full content available at:
https://github.com/apache/incubator-superset/issues/5700 ]
This message was relayed via gitbox.apache.org for [email protected]
