Stacked bar chart issue with modern charts

[leventeholyba]

Hey!

I've just recently swapped to modern charts on one of my dashboards and I've noticed that one of the charts doesn't work properly. Previously with the 'old' chart types it worked just fine, so I wanted to share my situation and ask for a solution.

I created a simple column chart with a breakdown dimension. The base of the breakdown was a custom-sized bin on an existing value in the data source (I tried with a calculated fields instead of the bins but I had similar results). As a bar chart everything works (I can see the visual and the breakdown dimension is properly applied), but when I change the visual to a stacked bar chart (the wanted format), I experience something strange. The outline of the visual is on the page but the content of the chart is missing (I can select and see the blue outline but there's no stacked bar chart in the visual)

I tried this process with a field as the breakdown dimension that is a default field in the data source (not calculated field, bin or group) and Looker Studio successfully created the stacked bar chart.

Has anybody experienced this issue? How can I resolve this?

Thanks in advance!

[exerlanda]

Hi,

I've got a similar issue. I have a data source with 3 fields: job_date, MB_processed, and user_email.

Previously, I had a stacked bar chart that displayed MB_processed by user_email per day. However, after enabling the modern chart, when I use user_email as a breakdown dimension, nothing is displayed (see the right chart in the screenshot). If I remove the breakdown dimension, the total MB_processed is displayed.

Has anyone else experienced this or found a solution?

Thanks!

[EdgarA]

Hello,

Thanks for reaching out and reporting these issues! I tried replicating this but was unable to.

Are you still seeing these issues? If so, can you share an example report with data-studio-help@google.com so we can take a look?

Thank you! 

[exerlanda]

Hello,

On my side, I'm still seeing the same issue. Let me try to reprodue the error with a copy of the data set and share it with you later.

Thank you.

[exerlanda]

Hi,

It looks like the problem comes from having the "@" characters in the field. In my case, I solved the issue by creating a new field "user_name" using the formula "REGEXP_EXTRACT(user_email, '^([^@]+)')". (I have shared the dashboard with data-studio-help@google.com)

[alexmmredhat]

Hi! I recently found out that there is a big limitation on stacked bars charts... The max amount of allowed series are 20, so in my case that I would like to represent up to 36 series categorized in 5 groups, I cannot do that due to that limitation I posted.

Is there any news or updates at sight to solve this issue?

[leventeholyba]

Unfortunately I can't really share the report because it uses company data but I can show you some screenshots:

Visual as bar chart
- work fine
- but it shows the data in different columns

Same settings but with stacked bar chart
- visual there but shows nothing
- shows visual if I choose a non-custom made field as the Breakdown dimension (Passed Time Group field seems to be the problem)

Passed Time Group field
- Uses Passed Time Days field (date difference between two dates)
- I tried to use bins in order to create groups

I hope this is enough for you to be able to take a look at this issue. Thanks in advance!