Stacked bar chart from dataset

[fanselm]

Hi all,

I’d like to display the following dataset using an XYChart as a stacked bar chart:

I’m having issues figuring out how to configure the XYChart.

Column WMS_CUTOFF should be x-axis,
y-axis would be the stacked ORDER_STATE with AMOUNT.

New to this and wasn’t able to find an exact manual.

Thanks!

[Samg23]

This should send you in the right direction.

Stacked Bar Chart in Perspective - Detailed Steps

Few months ago I needed to create a stacked bar chart and ran into issues (Perspective 8.0.14 Time Series Bar Chart width - #3 by arun1). There are few posts here but they don’t give a full picture. Here are the steps that I took to create one: First it is worthwhile to note that we need to use the XY chart and not the TimeSeries chart because the width of the bar chart is calculated automatically based on the amount of data in the x-axis so if you have sparse data in a wide time range then th…

[fanselm]

Thanks - that helped me a ton!
Just needed to edit my query so I pivot every state in its own column.

Thanks