Single 100% stacked bar chart

Data Studio Data Studio Q&A
1

I have data in a google sheet

Category Orders
S 40
S 40
A 10
A 10

How can I create a single stacked bar chart to appear like this?

Beginner_2-1742219831995.png

Thanks

2

Hi,
To get this done, start by creating a dimension called “Category holder” in the calculated field.
Next, set your chart type to a 100% stacked bar chart. Then:

  1. Drag “Category holder” and drop into the dimension field.
  2. Use Category as the breakdown dimension.
  3. Set Orders as the metric.
    That should give you the expected chart!
    For reference and expected results, click the link below:
    https://lookerstudio.google.com/reporting/e84b3fb0-31aa-4d96-967a-458b62188e02/page/mZmCF

Sichali1_0-1742224046329.png
Sichali1_0-1742224046329.png1100Ă—623 19.3 KB

3

Hi

Thanks for reading and replying.

What should the calculation/value in the newly created “Category Holder” dimension be?

I tried checking via the reference dashboard you created but did not have access to your data set.

Thanks

4

Hi,

Here’s a picture of the calculation for reference.

Sichali1_0-1742226911503.png
Sichali1_0-1742226911503.png757Ă—257 11.3 KB

5

Great,

I am getting same results as you = the results I want

Thanks for your help.