Serial Chart Count Mismatch

Question

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.

Manager_HMWSSBCDC · Answer

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.

jcarlson · Answer

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 · Answer

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