How to Make Stacked Column Chart with Multiple Series?

Question

Hi Appian Community! 
 I have a requirement where in the column chart below, I need to show a breakdown of the data for each bar of all the series based on the date. 
 
 I had to manipulate the dataset so using a record type was not possible. Now I have my data structured where x-axis is dates, and y-axis is the percentage of each area of the office's seat booking. How do I show within each bar, a breakdown of say half is booking type A and the other half is booking type B?

Stefan Helzle · Answer

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.

Shubham Aware · Answer

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"
) Each data array must be index-aligned with categories.

Shubham Aware · Answer

Doesn&rsquo;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.

Shubham Aware · Answer

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