Hi Randy,
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 2015-06-05 17:43, Emma Kassy wrote: > 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 <[email protected]> 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 [1] >> E-mail: [email protected] >> Skype: wilsonrandy_us >> [2] >> Stronger health systems. Greater health impact. >> [3] [4] [5] >> www.msh.org [2] >> _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._ >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users [6] >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-users [6] >> More help : https://help.launchpad.net/ListHelp [7] > > -- > > Thank you and Kind Regards > _Immarcqulate. A (Emma Kassy) _ > > _"You miss 100% of the shots you don't take."_ > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users [6] > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users [6] > More help : https://help.launchpad.net/ListHelp [7] Links: ------ [1] tel:%2B250%20788308835 [2] http://www.msh.org/ [3] https://www.facebook.com/ManagementSciencesForHealth [4] https://twitter.com/MSHHealthImpact [5] https://www.youtube.com/user/MSHHealthImpact [6] https://launchpad.net/~dhis2-users [7] https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
