For a tutorial video that walks you through the process of using the Open Data Bits library of documentation to build your own open data mashups, we have created a video that can be watched by clicking here.

Data Source Link

https://data.cityofchicago.org/Health-Human-Services/Census-Data-Selected-socioeconomic-indicators-in-C/kn9c-c2s2

Available Access Formats

API OData CSV JSON RSS XLS XLXS XML

Sources and Modeling

Row Color Derived Column
Row Color Column Not Used by Open Data Bits

Logical Model

Calculated Columns & Calculations

Name DAX Expression Type
Pct of Housing Crowded Pct of Housing Crowded:=AVERAGE([percent_of_housing_crowded]) Calculation
Pct Households Below Poverty Pct Households Below Poverty:=AVERAGE([percent_households_below_poverty]) Calculation
Pct 16+ Unemployed Pct 16+ Unemployed:=AVERAGE([percent_aged_16_unemployed]) Calculation
Pct Aged 25+ without High School Diploma Pct Aged 25+ without High School Diploma:=AVERAGE([percent_aged_25_without_high_school_diploma]) Calculation
Pct Aged Under 18 or 64+ Pct Aged Under 18 or 64+:=AVERAGE([percent_aged_under_18_or_over_64]) Calculation
Per Capita Income Per Capita Income:=AVERAGE([per_capita_income_]) Calculation
Hardship Index Hardship Index:=AVERAGE([hardship_index]) Calculation