N/A's for Number of Employees on place pages

[jspeis]

See /profile/geo/lowell-ma/

[cnavarreteliz]

@jspeis I just checked and we haven't data from Lowell, MA (16000US2537000)

https://redwood-api.datausa.io/ui/#eyJkcmlsbERvd25zIjpbWyJHZW9ncmFwaHkiLCJQbGFjZSIsIlBsYWNlIl1dLCJjdXRzIjpbW1siMTYwMDBVUzI1MzcwMDAiXSxbIkdlb2dyYXBoeSIsIlBsYWNlIiwiUGxhY2UiXV1dLCJjdWJlIjoiYWNzX3lnc2lfZ2VuZGVyX2J5X2luZHVzdHJ5XzEiLCJtZWFzdXJlcyI6WyJXb3JrZm9yY2UgYnkgSW5kdXN0cnkgYW5kIEdlbmRlciJdfQ==

[cnavarreteliz]

Should we have data for Lowell, MA?

Meanwhile, I'm hiding N/A values from stats.

[jspeis]

I would want to confirm with Walther but there does seem to be a similar cube with the data?

https://redwood-api.datausa.io/ui/#eyJkcmlsbERvd25zIjpbWyJZZWFyIiwiWWVhciIsIlllYXIiXV0sImN1dHMiOltbWyIxNjAwMFVTMjUzNzAwMCJdLFsiR2VvZ3JhcGh5IiwiUGxhY2UiLCJQbGFjZSJdXV0sImN1YmUiOiJhY3NfeWdzaV9nZW5kZXJfYnlfaW5kdXN0cnlfY18xIiwibWVhc3VyZXMiOlsiV29ya2ZvcmNlIGJ5IEluZHVzdHJ5IGFuZCBHZW5kZXIiXX0=

Usually "c" cubes are "collapsed" versions of the tables meaning that they will have fewer options for the kinds of industries/occupations but when using it anyways to aggregate for a place I would think this would be ok? (assuming the totals for the C cube match the totals for the other cube in other places, like New York for example)

[cnavarreteliz]

@jspeis @hwchen @davelandry Investigating more deeply I found the bug.

Logiclayer returns data from acs_ygsi_gender_by_industry_1 and it should return data from acs_ygsi_gender_by_industry_5.

https://redwood-api.datausa.io/ui/#eyJkcmlsbERvd25zIjpbWyJZZWFyIiwiWWVhciIsIlllYXIiXV0sImN1dHMiOltbWyIxNjAwMFVTMDYwNjMwOCJdLFsiR2VvZ3JhcGh5IiwiUGxhY2UiLCJQbGFjZSJdXV0sImN1YmUiOiJhY3NfeWdzaV9nZW5kZXJfYnlfaW5kdXN0cnlfY181IiwibWVhc3VyZXMiOlsiV29ya2ZvcmNlIGJ5IEluZHVzdHJ5IGFuZCBHZW5kZXIiXX0=

[davelandry]

@cnavarreteliz can you post the logiclayer query that is returning the incorrect table?

[cnavarreteliz]

@davelandry https://redwood.datausa.io/api/data?Geography=16000US0606308&measure=Workforce%20by%20Industry%20and%20Gender,Workforce%20by%20Industry%20and%20Gender%20Moe

[davelandry]

Found the problem and pushed a fix, will updated redwood later today.