Serial Chart Count Mismatch

[Manager_HMWSSBCDC]

Hi,

I configured a dashboard with my CNG stations data, i configured a serial chart which shows year and month count and data source for both is same, but the count for year serial chart its showing 12 where as for month serial chart its showing 13 and in my attribute table count is 13. 

Can anyone able to spot the issue.

[jcarlson]

Is it possible that one of the records has a null record for "year"? What does the data actually look like, are these date fields, or strings/numbers corresponding to the month and year?

[Manager_HMWSSBCDC]

There are no two columns as "Year" and "month", The year and month are parsing from a date field.

[jcarlson]

Well, that is interesting. Any chance the data or dashboard are public? Or at the very least, could you share the 13 date values? I'd like to try and recreate the issue myself to understand it better.

[Manager_HMWSSBCDC]

Out of 13 dates, There is date of 29-12-2021, if I change this value to below 24-12-2021 then the count is 13 and if the value is above 24-12-2021, then the count of this record is being displayed in 2022 year. I don't really why its happening.