Is there a way to apply symbology based on field names as well as the values per each field?
I have a road layer where the fields are years and each road segment has an attribute value of 1 (had work done in that year) or 0 (no work done that year).I would like to apply symbology that shows road segments with attribute value of 1 in 2018 to be blue, 2017 to be red, 2016 to be green, etc. I have fields from 2000 to 2018 so more than the 3 fields that you can bring into the 'multiple attributes' symbology option.
I know how to pick all roads that had work done and apply a symbology to that but how do I also add in the further distinction of year?