Hi, First time using Metabase and it looks very good for the purpose. While rebuilding reports in Metabase I encountered an issue with displaying Ordinal values as Opposed to a Timeseries on the X-Axis.
The char(7) field used is formatted YYYY-DD and represents monthly results. I need the year-month below each column. Can’t do with less precise and fewer Timeseries labels. The result though is the for instance “2019-08” is being reformatted as August 1, 2019, 12:00 AM. This would suggest results up to July 2019. Basically the results shown in the chart are all ‘shifted’ by one month.
How do I get Metabase to display ordinal values as they are? In this case, YYYY-MM as they are stored in the database and not displayed as a misleading date.
edit: specified that the column discussed is char(7)