search

DataUSA / datausa-site

The most comprehensive visualization of U.S. public data —
www.datausa.io
GNU Affero General Public License v3.0
97 stars 28 forks source link

errors for locations with a University but no graduates #1017

Closed davelandry closed 2 years ago

davelandry commented 2 years ago

https://wad.datausa.io/profile/geo/tracy-manteca-lathrop-cities-puma-ca#education

azapatam commented 2 years ago

tracy-manteca-lathrop-cities-puma-ca#education is working :)

Do you have other examples of small locations to test that the changes applied in that profile are effective in other profiles?

azapatam commented 2 years ago

Another thing, I noticed that many N/As arise because year=latest is used in the generators... but there are cases where there is data for 2017 and 2018 and year=latest "assumes" a year=2020 and returns no data.

image image
davelandry commented 2 years ago

@azapatam oh no! this is a similar problem to what we started having in PUMS, where certain occupations are not present in the latest year. In that case... we started doing year=all in the queries, and manually detecting/extracting the max from the payload 😞

Not the most ideal solution, but we should either hide N/As or use this logic to show previous year's data.

azapatam commented 2 years ago

I did that! I bring all the years and show the statistics for the last available year. I agree that it is not optimal, but it works!