How to Make Stacked Column Chart with Multiple Series?

I assume you tried setting the "Stacking" parameter to NORMAL or PERCENT_TO_TOTAL?

If yes, I am not sure what exactly you try to achieve.

Use stacking: "NORMAL" in a!columnChartField and define one a!chartSeries per breakdown type:

a!columnChartField(
  categories: local!dates,
  series: {
    a!chartSeries(label: "Type A", data: local!typeAData, color: "GREEN"),
    a!chartSeries(label: "Type B", data: local!typeBData, color: "BLUE")
  },
  stacking: "NORMAL"
)

hi Stefan, always good to hear from you. Yes I tried those but the result is my 3-5 bars will be stacked into 1 for each day.

I want to keep them separate. and within each bar, show stacking of 2 booking types.

Thanks for the code sample. Let me try with 2 chart series for each day

Tried it with both staciking is "NORMAL" or "PERCENT" and the chart became just 1 bar with the breakdowns in there for each day:

Is it possible to still have 3-5 bars like in my original, but for each bar, have a breakdown of 2 booking types?

Doesn’t support grouped + stacked simultaneously.
Workaround you can try : Use 2 separate stacked column charts side by side in a a!columnsLayout:
Chart 1: Office areas stacked (your original)
Chart 2: Booking type breakdown stacked
Same date x-axis on both - user can visually correlate between the two charts.

Thanks for your suggestion. I guess thats the closest workaround there can be

one more question is: even if I use a record type, the stacking effect that I want to achieve by showing grouped + stacked combination is not possible either?

Record type doesn't matter here - it's a limitation of a!columnChartField itself, not the data source.

Then try to prepare the data in a way that the column chart can display it. If you want two columns for each day, create two data points for each day.