Special Graphs - multiple lines/bars

[AmoryH]

See following for graphs that would require special attention. You can view what they look like in the report - http://www.phila.gov/health/commissioner/DataResearch.html

• Life expectancy
o Over time - combine male and female on one graph
o Race/ethnicity – Combine male and female on one graph

• Gap in life expectancy
o Over time - combine male and female on one graph

• Child obesity
o Race/ethnicity – combine male and female on one graph

• HIV transmission categories
o Over time – Combine all 3 on one graph
o Race/ethnicity – Combine all 3 on one graph and add note “Race/ethnicity data categories do not sum to 100 due to “other” transmissions not shown.”

• Elevated blood lead levels
o Over time – combine both the 5-9 and 10+ thresholds on one graph

• 3-Dose HPV vaccine
o Top 10 – combine boys and girls on one graph

• Air quality
o Over time – combine good, moderate, and unhealthy on one graph

• Advanced or proficient reading skills and ELA achievement
o Over time – combine these two indicators. One is for 2006-2014 and the other is one data point for 2015. Don’t connect the line between 2014 and 2015. This one is tricky so maybe we can talk about it.

• On time high school graduation
o Race/ethnicity – combine male and female on one graph

• Housing cost burden
o Over time – combine housing cost burden and severe housing cost burden on one graph
o Top 10 – combine housing cost burden and severe housing cost burden on one graph

[MeaganLP]

Awesome, Amory, thanks!
A few additional graphs would be:

• Adult Obesity: overtime by race/ethnicity

• Adult Diabetes: overtime by race/ethnicity

• Adult Smoking: overtime by race/ethnicity

[AmoryH]

I didn't include the over time by R/E in the data I sent originally so @laurenancona let us know if and when you'd like to look at it.

[AmoryH]

@laurenancona let me know if this requires special data formatting.