Show calendar month as month and year on aggregate query grouping

If you use a basic model rather than an aggregate, you should be able to select a date field and group by calendar month. If the chart series aggregation options don’t work to get the data you want, I’ve had some luck using a basic model to set the axis on the chart, then use an aggregated model to display the series.