topic Comparing percentages over time. in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/comparing-percentages-over-time/m-p/620577#M27581 <HTML><HEAD></HEAD><BODY><P>I have two groups of census tracts; not only geographically located, but also two specific years (2012 &amp; 2017) that contain education statistics. I would like to assemble a “side-by-side” comparison based on values representing HS Diploma, GED Alt., Associates, Professional, Doctorate, etc. for each included tract. In some tracts, the higher education counts are non-existent for the earlier year but now has a volume for the latter. I’ve calculated the percentages and would like to provide a tract level “% of change” value. Because some induvial poly tracts include a zero count, it returns a zero result of the individual tract calculation. Ex: 2012 Doctorate graduates 0, 2017 Doctorates 7. The amount of increase is 7.</P><P>(7/0) *100= 0.</P><P>I understand when the group is summarized, all categories list a value greater than 0 and allows for a grouped statistic. But, I’m attempting to also display at tract level for color ramp representation. Does anyone have experience or suggestions on such a calculation approach?</P><P>Thanks for any suggestions provided.</P></BODY></HTML> Wed, 04 Dec 2019 14:19:45 GMT KevinBurns 2019-12-04T14:19:45Z Comparing percentages over time. https://community.esri.com/t5/arcgis-pro-questions/comparing-percentages-over-time/m-p/620577#M27581 <HTML><HEAD></HEAD><BODY><P>I have two groups of census tracts; not only geographically located, but also two specific years (2012 &amp; 2017) that contain education statistics. I would like to assemble a “side-by-side” comparison based on values representing HS Diploma, GED Alt., Associates, Professional, Doctorate, etc. for each included tract. In some tracts, the higher education counts are non-existent for the earlier year but now has a volume for the latter. I’ve calculated the percentages and would like to provide a tract level “% of change” value. Because some induvial poly tracts include a zero count, it returns a zero result of the individual tract calculation. Ex: 2012 Doctorate graduates 0, 2017 Doctorates 7. The amount of increase is 7.</P><P>(7/0) *100= 0.</P><P>I understand when the group is summarized, all categories list a value greater than 0 and allows for a grouped statistic. But, I’m attempting to also display at tract level for color ramp representation. Does anyone have experience or suggestions on such a calculation approach?</P><P>Thanks for any suggestions provided.</P></BODY></HTML> Wed, 04 Dec 2019 14:19:45 GMT https://community.esri.com/t5/arcgis-pro-questions/comparing-percentages-over-time/m-p/620577#M27581 KevinBurns 2019-12-04T14:19:45Z