Visualizing Longitudinal Data

HWhitty

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? 

 

DanielFox1

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.