Hi, I just updated to v0.36.6 with a mySQL Database.
When I create a bar chart in native query builder, I expect the names of the bars below them:
But when the number of shown bars switches to below 7, the names disappear:
Is there a trick in the new visualisation settings that I didn´t find yet? when I use row charts it works also with lesser columns, but unfortunately the bar chart is our default chart
Thanks for help! I checked github but didn´t find a related issue ...
Hi @EvaS
It would be very helpful if you also noted the previous version you were using. Otherwise I might think it’s a new problem in 0.36.6
I’m fairly sure you’re seeing this: https://github.com/metabase/metabase/issues/12699
Hi @flamber, thanks! on my staging environment I briefly had 0.35.4 installed and now 036.6. I don´t know more technical details and I didn´t see this problem in ß.35.4, but I also can´t remember I checked.
ok, something is weird here. I thought the problem is maybe that the column data are not classified as category in the data model, but in the following examples all column data are categories.
Here it works:
from bi_donation_values
where {{snippet: standard filter für receiver projekt}}
and product_tracking_computed in ("platform", "iframe", "matching_fund")
group by product_tracking_computed
Same code, different field as grouped column (only needed to ajust the filters to create < 7 columns):
from bi_donation_values
where {{snippet: standard filter für receiver projekt}}
and donation_created_at_month_local in (1,2,3,4)
group by donation_created_at_month_local
donation_created_at_month_local and category both are classified as category in the data model.
What do I miss?
@EvaS Not sure what’s going on, but anything involving SQL does not involve the Data Model.
It sounds kinda similar to this: https://github.com/metabase/metabase/issues/7310
The difference between the two is that one returns a string and the other a number.
thank you! it also appears when the column names are true/false…
I might need to use a sql snippet to map the donation_months to the month names to avoid that