Grid chart dimension has duplicate date values

[Didi420]

I want to display count of ID's by groups and months using grid chart.
For some reason, grid chart has duplicate month values as such:

Obviously it'd make more sense if there would be one row of September, October etc., but they're duplicating without any apparent reason. Same happens with year field.

My date fields in data load editor looks like that:

Date(Date#(Date, 'MMMM DD, YYYY'),'MMMM') AS Month,
Date(Date#(Date, 'MMMM DD, YYYY'),'YYYY') AS Year

thanks in advance

[Or · Accepted solution]

Your issue has nothing to do with the grid chart, but rather with using the wrong date function for the job. If you'd like to extract the month from a date, use MonthName() (or YearName() / Year() for the year). Date() does not change the underlying value, it only formats it in a specific manner, so in this case 01/01/2022 and 02/02/2022 would remain individual values when you use Date(Date,'YYYY') but would display 2022 in both cases.