I currently have a data file that has columns for each day over an 8-month period.
I am seeking of a way to create an interactive CARTO map that displays the change over time. I want to know if there is a way(or even possible) in Cartoframes or CARTO-VL that the animation over time can change by iterating through the date columns.
I know there is a way to display this change over time by making all date columns unique to each geography (polygon). The issue is I have nearly 850 geographies. Even limiting my dataset to 3 months, we are approaching 1 GB of data (due to the geometries of each field needing to be stored). The size won't generate a time series map on any library I've found or import to CARTO.
With the wide format (each date has its own field) the dataset is only 23MB for 8 months of data. I have not seen any examples iterating through columns but I feel there has to be a way (maybe I'm crazy).
Image of column sample: