search

ICTatRTI / coconut-analytics

Browserified & backboned version of coconut-reports
Other
2 stars 3 forks source link

Graph: Attendance #146

Closed gmcressman closed 8 years ago

gmcressman commented 8 years ago

image

This graph shows the number of index cases (reported by a health facility Out Patient Department [OPD]) by age (<5 Years of Age, 5+ Years of Age). The time scale is by week. That should be fine for us, but note that we could cross year boundaries. We need to handle that in the X-axis labeling.

I don't know why this is done as a bar graph. This isn't sensitive enough to show changes over time. I suggest we try this as a line graph, with two lines.

mikeymckay commented 8 years ago

There are at least 2 ways to do this already...but I think a new query will be better.

mikeymckay commented 8 years ago

Note that this graph does not show malaria cases, but rather the total number of people going to health facilities for any problem.

gmcressman commented 8 years ago

We don’t have those numbers in Coconut Surveillance. We should strike this graph, correct?

What other graphs should be on the priority list?

-gmc

Gordon M. Cressman Senior Program Director | Research Computing Division | RTI International Email: gmc@rti.orgmailto:gmc@rti.org | Office: +1 919 541-6363 | Mobile: +1 919 271-7003 | Skype: gmcressman

Was this email too brief? Here is whyhttp://emailcharter.org/

From: Mike McKay notifications@github.com Reply-To: ICTatRTI/coconut-analytics reply@reply.github.com Date: Friday, September 23, 2016 at 1:45 PM To: ICTatRTI/coconut-analytics coconut-analytics@noreply.github.com Cc: "Gordon M. Cressman" gmc@rti.org, Author author@noreply.github.com Subject: Re: [ICTatRTI/coconut-analytics] Graph: Attendance (#146)

Note that this graph does not show malaria cases, but rather the total number of people going to health facilities for any problem.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/ICTatRTI/coconut-analytics/issues/146#issuecomment-249257415, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AAUIKHHLEIx2NByz5zltT6dGgsQCcNB7ks5qtBArgaJpZM4JAhml.

mikeymckay commented 8 years ago

We do. Query is done, just testing it.

mikeymckay commented 8 years ago

view is weeklyDataCounter, group=true. I have included the zone (PEMBA/UNGUJA) at the beginning in case you are up to splitting this into two graphs.

mikeymckay commented 8 years ago

I should also mention that for this query you should not pass in a startkey to select the dates. You need to download the full dataset and then extract the appropriate dates. The full dataset is only 117KB so no need to optimize that one.

mikeymckay commented 8 years ago

As I expanded this query to also return the testing rate for #147 the result got bigger. So I moved the year and week to the front of the key. Now it's about 10KB for a year's worth of data. You can use startkey and endkey to limit the data that is being returned to the required date range:


start_key: [startyear, startweek]
end_key: [endyear,endweek, {}]

or even:

start_key: [startyear]
end_key: [endyear,{}]
gmcressman commented 8 years ago

Done. Closed.