How to Create a Combo Chart with Stacked Bars and a Line in Looker Studio

[Vinny_Alba]

I am trying to create a combo chart in Looker Studio with the following setup:

• Columns in my dataset:

  • D (Date) – X-axis

  • V (Numerical value) – Y-axis

  • L (Category) – Breakdown dimension

I want to achieve the following:

1. The bars should be stacked by L and display the sum of V.

2. The line should plot the same V values so that at each date (D), the height of the line matches the total height of the stacked bars.

3. The X-axis should be based on D (Date).

How can I configure the chart so that the line correctly represents the sum of the stacked bars at each date?

Any help would be greatly appreciated!

[sam8 · Accepted solution]

This should be possible! One way to get at this is to create a calculated field that sums V for all L. Then you can make this new field a line while the rest are stacked bars.

[Vinny_Alba]

Thanks a lot.