Great, thanks! It ended up working and i can filter by year. I do have one more question though.
I have an indicator that has "Total counters." Previously, it was a fixed number of 150 because it was counting the number of counters. But in reality, each year there are a different number of counters.
For example, in 2017, we only had 68, now in 2021 we have 115. The bike count example updates the "total sites" by year.
How do you suppose I format my data so that I can show this? I have an example table of my data. It shows that for the first three years, the count was zero, aka, we didnt have a counter.
Location | Year | Count |
Smith Rd | 2017 | 0 |
Smith Rd | 2018 | 0 |
Smith Rd | 2019 | 0 |
Smith Rd | 2020 | 456 |
Smith Rd | 2021 | 566 |