Need help in aligning data in XY chart/timeseries chart

[srinivasan_s]

I am working in charts. I need to recreate the data as below.

My table schema looks like this,

I tired to bind the data via named query to both charts but result is as below.
For Timeseries Chart:

For XY xhart:

I tired series, axis not able to get this kind. Any one here kindly help on this.

[Ujwal_Wankhede]

Hi
The chart type you want to replicate is a stacked and clustered column chart, as demonstrated in the amCharts demo:Example Stacked and Clustered Column Chart - amCharts

To render this chart, use the following JSON configuration.
The distance between two groups can be customized by modifying the renderer object properties. Note that these properties are not predefined, so you will need to add and configure them manually.
stackedxychart.json (52.9 KB)

[srinivasan_s]

Thank you for your reply. Searching this solution for long, but you have helped me out!