Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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