topic Serial Chart Count Mismatch in ArcGIS Dashboards Questions

Serial Chart Count Mismatch

Manager_HMWSSBCDC — Tue, 28 May 2024 16:08:23 GMT

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.

Re: Serial Chart Count Mismatch

jcarlson — Tue, 28 May 2024 16:26:09 GMT

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?

Re: Serial Chart Count Mismatch

Manager_HMWSSBCDC — Wed, 29 May 2024 05:17:54 GMT

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

Re: Serial Chart Count Mismatch

jcarlson — Wed, 29 May 2024 12:00:31 GMT

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.

Re: Serial Chart Count Mismatch

Manager_HMWSSBCDC — Sat, 01 Jun 2024 06:29:45 GMT

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.