nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Removing gaps between data in a dashboard serial chart?

PeterNielsen

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?

Najděte více příspěvků označených jako

Data and services

Accepted answers

DanielFox1

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."

All comments

DanielFox1

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.

KevinPiraino2

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.

DanielFox1

Hi @PeterNielsen

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

Parse dates

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.