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)
I replicated your question here and that is a bug when you try to build the chart by native query.
But if you try to build the chart by the Custom option, maybe you could have the result below:
I used the sample data available for metabase
Let me know if helped you
Hey Frederico thanks for givin it a go! Your result would be acceptable.
Unfortunately I still see the same effect. The query is basically selecting all rows from a view.
(I hope pasting the screenshot works like this…let’s see)
Actually I have this bug not when building a Native query. I used the Simple question option. And then selected the view (where all the complex logic resides)
Looking how you made it work Frederico, I think you group by an actual date field. At this point Metabase is smart enough not to pick an actual date since the grouping is by month.
In my case I have a char(7) column with something similar enough to a date and Metabase wants to be smart. Unfortunately :-(. Perhaps I reformat the column by adding a dash or asterisc in fron…hopefully Metabase then leaves it alone.
Unless this is a setting somewhere I could manipulate (what I was hoping for)
@Michael I think you’re seeing this issue - upvote by clicking on the first post:
That’s it! I didn’t find that. Thanks I’ll upvote!
For now I proceed like this