Column Chart

This should work OOTB. Did you try it? Do you have any specific question?

I have created a chart like the image below but I want to make it like the image above

Just create multiple chartSeries like here

Great job Stefan, but the task I am doing is a bit complicated because I am fetching data from a DSE

Then use queryEntity to fetch the data and create the chartSeries from it.

This is my code in the expression editor, could you tell me where should I make changes?

Seems like you are only aggregating the status. Didn't you want to aggregate the date first?

I'd also recommend that you try building this chart in design view. If you add one grouping for status and another for month, it should be really easy to set this up without writing any SAIL. The chart design view works with record types (either synced or DSE-backed), so it should work for you here.

I'd also recommend that you try building this chart in design view. If you add one grouping for status and another for month, it should be really easy to set this up without writing any SAIL. The chart design view works with record types (either synced or DSE-backed), so it should work for you here.