Visualizing Longitudinal Data

HWhitty — Wed, 29 Apr 2026 14:51:35 GMT

I have a dataset that is structured like this:

FY	County	StatA	StatB	StatC
2023	CountyA	1	2	3
2023	CountyB	2	3	4
2023	CountyC	3	4	5
2024	CountyA	4	5	6
2024	CountyB	0	1	2
2024	CountyC	1	2	3
2025	CountyA	2	3	4
2025	CountyB	3	4	5
2025	CountyC	4	5	6

...and so on for many counties, across many years.

I would like to create some interactive visualizations for this dataset, eventually in the form of a web app, but don't have much experience with time enabled layers or even just longitudinal data in general. From my understanding of time enabled layers in ArcGIS, I will need to change my dataset to look more like this, so that each county has only one record:

County	FY23_StatA	FY23_StatB	FY23_StatC	FY24_StatA	FY24_StatB	FY24_StatC	FY25_StatA	FY25_StatB	FY25_StatC
CountyA	1	2	3	4	5	6	2	3	4
CountyB	2	3	4	0	1	2	3	4	5
CountyC	3	4	5	1	2	3	4	5	6

Is my understanding correct? And is there a smarter way to go about visualizing this data that doesn't require reformatting?

Re: Visualizing Longitudinal Data

DanielFox1 — Thu, 30 Apr 2026 14:11:10 GMT

Hi @HWhitty

With the table at the moment I can't see why you can't use this format once you have joined the data to something spatial, date filters should be able to identify the date field or you can specify.

Re: Visualizing Longitudinal Data

AlfredBaldenweck — Fri, 01 May 2026 15:48:12 GMT

You may also want to look at Transpose Fields (Data Management)

topic Re: Visualizing Longitudinal Data in ArcGIS Pro Questions

Visualizing Longitudinal Data

Re: Visualizing Longitudinal Data

Re: Visualizing Longitudinal Data