We have been using the tracker module (multiple events with registration) to store imported quarterly data reported by Community Health Workers through rapidSMS. These CHWs are registered - and linked to the Health Centers that supervise them - then each quarter new datavalues are added counting the number of events the CHWs reported (children treated in through community case management, pregnant women registered, etc…). We couldn’t import into the regular datavalue table because there are around 1000 reporting CHWs per orgunit per period per dataelement and we didn’t want to extend the orgunit hierarchy to include 45000 CHWs.
The tracker data elements are numeric and the aggregation type is set to sum,
The imported data displays nicely in the tracker module, however when I run an event report or graph, the values are not summed. Instead the system produces counts in a frequency distribution like the chart below, basically the number of CHWs that reported 1 event, 2 events, 3 events etc…
What we need is a way to display the total number of events reported - e.g. total number of children treated, pregnant women registered.
Is this a bug or a feature. Is there some workaround that anyone can suggest?
Thanks,
···
Randy Wilson
*Team Leader: *Knowledge Management, Data Use and Research
Hi Randy,
While using the Event Report there are two options, Aggregate Values and Individual Values.
Select Aggregate Values for totals and Individual values for details of each client.
However, I do not think you are able to generate Aggregate values with Event Visualiser.
···
On Fri, Jun 5, 2015 at 12:48 PM, Wilson, Randy rwilson@msh.org wrote:
We have been using the tracker module (multiple events with registration) to store imported quarterly data reported by Community Health Workers through rapidSMS. These CHWs are registered - and linked to the Health Centers that supervise them - then each quarter new datavalues are added counting the number of events the CHWs reported (children treated in through community case management, pregnant women registered, etc…). We couldn’t import into the regular datavalue table because there are around 1000 reporting CHWs per orgunit per period per dataelement and we didn’t want to extend the orgunit hierarchy to include 45000 CHWs.
The tracker data elements are numeric and the aggregation type is set to sum,
The imported data displays nicely in the tracker module, however when I run an event report or graph, the values are not summed. Instead the system produces counts in a frequency distribution like the chart below, basically the number of CHWs that reported 1 event, 2 events, 3 events etc…
What we need is a way to display the total number of events reported - e.g. total number of children treated, pregnant women registered.
Is this a bug or a feature. Is there some workaround that anyone can suggest?
Thanks,
– Randy Wilson
*Team Leader: *Knowledge Management, Data Use and Research
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
I had this issue and discussed with Jan a while back. It is a feature but he agreed that there is use case for summing values as well as counting. If you have three values say, 25, 30 and 10. Right now the event reports will give you a count of 1 for each of these values but what we need is a value of 65.
The only work around I can think of for now is to use the aggregation query buildrr. Choose “Sum of data elements” for your aggregation operator. This means you can analyse your data as aggregate values.
Hope this helps.
Busoye
···
On Fri, Jun 5, 2015 at 12:48 PM, Wilson, Randy rwilson@msh.org wrote:
We have been using the tracker module (multiple events with registration) to store imported quarterly data reported by Community Health Workers through rapidSMS. These CHWs are registered - and linked to the Health Centers that supervise them - then each quarter new datavalues are added counting the number of events the CHWs reported (children treated in through community case management, pregnant women registered, etc…). We couldn’t import into the regular datavalue table because there are around 1000 reporting CHWs per orgunit per period per dataelement and we didn’t want to extend the orgunit hierarchy to include 45000 CHWs.
The tracker data elements are numeric and the aggregation type is set to sum,
The imported data displays nicely in the tracker module, however when I run an event report or graph, the values are not summed. Instead the system produces counts in a frequency distribution like the chart below, basically the number of CHWs that reported 1 event, 2 events, 3 events etc…
What we need is a way to display the total number of events reported - e.g. total number of children treated, pregnant women registered.
Is this a bug or a feature. Is there some workaround that anyone can suggest?
Thanks,
– Randy Wilson
*Team Leader: *Knowledge Management, Data Use and Research
Rwanda Health System Strengthening Activity
Management Sciences for Health
Rwanda-Kigali
Direct: +250 788308835
E-mail: rwilson@msh.org
Skype: wilsonrandy_us
Stronger health systems. Greater health impact. www.msh.org
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
good question. This is in fact partly supported in version 2.19. The limitation is that you can only aggregate over one data element per report. In 2.20 we plan to support aggregation of tracker data elements / attributes similarly to how you can aggregate routine data values.
What you can do in 2.19 or now is to:
Decide on which data element you want to aggregate (e.g. “Pregnant women registered”)
In event report/visualizer, go to Layout
In the “Value” area, select “Sum” as aggregation operator, and select your data element in the value drop-down
Select the other dimensions you want for your report, e.g. you can have organisation units on rows and quarterly periods on columns.
The pivot table (or chart) will now show you the sum of “pregnant women registered” by org unit/quarter.
Just to illustrate the concept have a look at this favorite on demo, which gives you average weight of patients by quarter and gender:
Again, we plan to integrate aggregation of tracker data elements / attributes in the regular pivot table app for 2.20 which will be what you really need so stay tuned for that.
Screenshot:
regards,
Lars
···
On Fri, Jun 5, 2015 at 11:48 AM, Wilson, Randy rwilson@msh.org wrote:
We have been using the tracker module (multiple events with registration) to store imported quarterly data reported by Community Health Workers through rapidSMS. These CHWs are registered - and linked to the Health Centers that supervise them - then each quarter new datavalues are added counting the number of events the CHWs reported (children treated in through community case management, pregnant women registered, etc…). We couldn’t import into the regular datavalue table because there are around 1000 reporting CHWs per orgunit per period per dataelement and we didn’t want to extend the orgunit hierarchy to include 45000 CHWs.
The tracker data elements are numeric and the aggregation type is set to sum,
The imported data displays nicely in the tracker module, however when I run an event report or graph, the values are not summed. Instead the system produces counts in a frequency distribution like the chart below, basically the number of CHWs that reported 1 event, 2 events, 3 events etc…
What we need is a way to display the total number of events reported - e.g. total number of children treated, pregnant women registered.
Is this a bug or a feature. Is there some workaround that anyone can suggest?
Thanks,
– Randy Wilson
*Team Leader: *Knowledge Management, Data Use and Research
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
