apimastery commented on issue #5910: Can't make a timeserie if date is TIMESTAMP WITHOUT TIME ZONE (postgres) URL: https://github.com/apache/incubator-superset/issues/5910#issuecomment-436101373 Here is how I fixed this when running a clone of the repo's master branch from 2018-11-01 and the Docker install (after few "adjustments" to make it work). I hope this will help others until it is permanently fixed... For the "World's Bank Data" dashboard: - Select Sources --> Tables from the top-level menu. - Click on the "Edit" icon for the wb_health_population table. - Click on the "List Columns" tab. - Scroll down to the "year" column. - Click on the "Edit" icon for the "year" column. - In the "Expression" box, enter "year ::timestamptz" (without the double quotes). - Click on the "Save" button. - Access/Refresh the dashboard. I had another issue with the "World's Bank Data" dashboard - some charts were erroring out with 'column "xxxx" does not exist'. For example, 'column "sp_pop_totl" does not exist'. To fix: - Select Sources --> Tables from the top-level menu. - Click on the "Edit" icon for the wb_health_population table. - Click on the List Metrics tab. - Find the metric for the offending column. For example, sum__SP_POP_TOTL and click on its "Edit" icon. - Surround the column name in the "SQL Expression" field with double quotes. For example, change it from SUM(SP_POP_TOTL) to SUM("SP_POP_TOTL") HTH
---------------------------------------------------------------- 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
