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?
