NYCPlanning / data-engineering-qaqc

streamlit app for data engineering
https://edm-data-engineering.nycplanningdigital.com
1 stars 0 forks source link

PLUTO: Improve the NULL graph #188

Closed AmandaDoyle closed 1 year ago

AmandaDoyle commented 2 years ago

LS comment: "Null report - needs to show all fields that might have a null value (or we can talk about removing this report since we're capturing nulls in the difference graphs)"

Currently, the X axis of the Null report does not show all field names, so it's a little confusing. As LS mentioned since the other reports now capture NULL records, we can A) remove this graph, OR for usability we can B) Make it super big so that all fields are captured or C) Limit it to report fields where NULL is a value in the field (this is probably the hardest, but preferred). For example, BBL should never be NULL in PLUTO, so this should not be in this graph, but Zoning District 4 can have NULL values. Therefore, this graph would only report fields where NULL is a value in that field.