add profile stat for diabetes
Closed this issue · 6 comments
Once Marcio has closed this issue, use the local logiclayer to add a need to the profile which fetches the "Diabetes" measure value for the latest year from the 500 Cities cube and add it to the page underneath the population statistic.
Sounds good. The link to the Marcio's issue is not working. Could you please check that again?
@rbaheti you weren't listed as collaborator on that private repo, all set now!
I see, thanks!
@rbaheti Marcio has updated the cubes, so for the time being you should be good to implement this stat for Dearborn (id 16000US2621000): http://ah-aspen.datawheel.us/ui/#eyJkcmlsbERvd25zIjpbWyJHZW9ncmFwaHkiLCJDaXR5IiwiQ2l0eSJdXSwiY3V0cyI6W1tbIjE2MDAwVVMyNjIxMDAwIl0sWyJHZW9ncmFwaHkiLCJDaXR5IiwiQ2l0eSJdXV0sImN1YmUiOiI1MDAgQ2l0aWVzIiwibWVhc3VyZXMiOlsiUG9wdWxhdGlvbiBDb3VudCIsIkRpYWJldGVzIERhdGEgVmFsdWUiXX0=
@MarcioPorto are these values number of people out of the total population? for example, in that cube query it says 230.6 for diabetes, and 196,306 for population count, so would it be safe to say that 0.11% of the population has diabetes?
If that's the case, @rbaheti please display the number as that percentage (data value / population * 100)
Sounds good.
@davelandry The values are supposed to be the percentage already. And I am getting 98,153 for the population and 9.3% diabetes in the query you mentioned in your comment.