topic Re: Removing gaps between data in a dashboard serial chart? in ArcGIS Online Questions

Removing gaps between data in a dashboard serial chart?

PeterNielsen — Thu, 22 Jun 2023 16:17:21 GMT

Hello-

I am having an issue with a serial chart in a dashboard I am working on. I am making either a bar or a line chart that is updated by week to show the changes in the categorization of my data.

My issue is I have added in historical data that is not weekly and has inconsistent gaps.

My data currently looks like this:

10/6/2021

10/6/2022

11/1/2022

2/1/2022

5/1/2022

5/8/2022

5/15/2022

5/22/2022... and so on weekly

The chart creates huge gaps for the time when the dashboard isn't weekly, making the chart completely unreadable as a bar chart and pretty useless as a line chart.

Any help fixing this?

Re: Removing gaps between data in a dashboard serial chart?

DanielFox1 — Fri, 21 Jul 2023 15:49:47 GMT

Hi @PeterNielsen

Have you tried using the Connect Gaps button? Please an extract from the following documentation below:

Parse dates

"Serial charts that have parse dates enabled, and are either a line or smoothed line chart, have the option of connecting gaps caused by missing data points. In the Series tab of your serial chart's configuration, use the Connect gaps toggle button to connect or create breaks in your chart where there are missing data points such as empty values for that time period."

Re: Removing gaps between data in a dashboard serial chart?

KevinPiraino2 — Fri, 15 Dec 2023 17:12:12 GMT

Hi @DanielFox1,

Thanks for this information. Relating to the "Parse Dates" toggle, is there a way to parse on weeks? I have an end user that is trying to visualize data that is recorded on a weekly basis and the format of the date is Year-Week.

Re: Removing gaps between data in a dashboard serial chart?

DanielFox1 — Tue, 19 Dec 2023 09:22:05 GMT

Hi @KevinPiraino2

Reviewing the documentation linked above there does not appear to be this option for parsing by weeks. I would recommend reaching out to the Esri Ideas page to see if this suggestion has been made already or could be added.

The parse dates focus on the following:

Second
Minute
Hour
Day
Month
Year

This then expands into various combinations as you can see in the documentation.