I am using CartoDB and am mapping water quality data in a particular region in Mexico.
My organization has data of multiple locations over many years.
Since we are showing the same data of the same location but over multiple years, I wanted to have a info window that allows the user to scroll through each year of data.
However, each point was plotted on top of one another so that you can only see and click on one point.
I know I can just create new columns titled Date 2, Date 3, and Fluoride 2 and Fluoride 3 and so on, but this isn't as visually pleasing and not all of the points have the same number of data or years tested.
Therefore, many windows would have more empty fields.
Is there a way to have my info window allow the user to scroll through the data for different years so that all of the stacked data points can be visible through scrolling through the info window?
In ArcMap, this feature is possible when any data points have the same geometry, but I can't seem to figure it out with CartoDB.