Leslie300 opened a new issue #4813: datetrunc is not suported URL: https://github.com/apache/incubator-superset/issues/4813 the time works nicely, but as soon as I am trying to adjust the time grain i get thrown this error. (psycopg2.ProgrammingError) function date_trunc("unknown", character varying) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. [SQL: "SELECT refferer AS refferer,\n DATE_TRUNC('week', real_time) AT TIME ZONE 'UTC' AS __timestamp,\n count(*) AS count\nFROM\n (SELECT count (event) as count,\n initial_referring_domain as refferer,\n real_time\n FROM metrics\n WHERE event = 'adventureView'\n group by initial_referring_domain,\n real_time\n limit 100) AS expr_qry\nWHERE real_time >= '1918-04-12 00:00:00'\n AND real_time <= '2018-04-12 15:55:53'\nGROUP BY refferer,\n DATE_TRUNC('week', real_time) AT TIME ZONE 'UTC'\nORDER BY count DESC\nLIMIT 50000"] (Background on this error at: http://sqlalche.me/e/f405)
---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services
