Date mismatch with Chart

Need help Database
1

I have following date values in database:
Values
I am aggregating values on month, below is the rule for X-axis:
X-axis rule
Following is the rule for Y-axis:
Y-axis rule
I have grouped on month via given rule in both the cases:
Group by clause
But in the graph, all the rows are getting mapped to Jan & Feb instead of Jan, Feb and March. Can someone help with what I am missing here?
I am using Chart JS plugin.

1 Like