Bar charts with weekly data messed up


#1

Data that is grouped by week - using FORMAT_DATE("%Y-%V", DATE(timestamp)) in BigQuery standard SQL - is displayed in a bar chart (or line chart) like this:
image

The underlying figures and the grouping are ok though, if switched to table format everything looks fine, also the week numbers:

image

Any suggested solution? This seems to be a bug in how the chart interprets and groups the week numbers, rather as month than week.

Thanks for your help!


#2

Looks like you get bitten by that Metabase is “clever” and sees it’s a date type so it displays the time dimension as dates - in Metabases standard date format. (Americans don’t care much for week numbers). Maybe as a work-around you can cast it to a text type?

Improvements for the X axis labels have been added to the next upcoming major release 0.29 wheneven it’s ready:


#3

Added to corresponding github issue #7236, apparently it’s regular numbers too not just dates that can be interpreted by Metabase as a regular date. Concatenating a special character at the beginning of the category label solved the problem in this particular case.