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?
Discussion posts and replies are publicly visible
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" )
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 stackedSame 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.
thanks shubham for your confirmation