Clustered Stacked Bar Chart

[nico1644]

Hello,

I am trying to get a bar graph(s) in which there are four categories that represent different bars, the measures are pivoted creating separate colors for the stack in the bar. Then also have each of these groups over a week, one group for each day. 

Something along the lines like this. But having the days having a wider gap.

The closest I can get to it is similar but each value label has it’s own part and I’d like it to be grouped. As well as the bars being closer for each category and wider separated by each day. 

[mathias_luyten]

Searching for a similar functionality

[chriswragge]

Me too...

[Manil]

Me too! Pretty simlpe to do in python, can we expect this functionality in Looker?

[Ayu1]

Looking for the same function...

[Charles_Dataviz]

Hi, Check this article.

https://medium.com/analytics-vidhya/several-data-interpretation-problems-with-stacked-bar-chart-and-...

[Nadirfb]

same here

[GenDemo]

+1

[ezzie]

you can!

1. pivot by date (the larger category)
2. leave the 4 categories (the smaller one) as a regular dimension
3. select “stacked” for series positioning
4. set the grid layout to “by pivot”
5. set the number of charts per row to 7 for this case, or the max of 12 for general case

[gomax]

you can!

1. pivot by date (the larger category)
2. leave the 4 categories (the smaller one) as a regular dimension
3. select “stacked” for series positioning
4. set the grid layout to “by pivot”
5. set the number of charts per row to 7 for this case, or the max of 12 for general case

This doesn’t work. Stacked option does not work with regular dimension.

[alwang]

Any updates on how to implement a clustered stacked bar chart in Looker? Seems so simple in Tableau but impossible in Looker

[georgeabj]

Any updates regarding this issue ?