dhis2-users team mailing list archive

[Karina Dian Lestari <karinadnlstr@xxxxxxxxx>]

Hi all,

I have some data that need to be counted. One of the data is about malaria
diagnosis method examination. On my excel sheet, this is a one column that
called 'method' and filled with either microscopy, RDT, or both. I use
several approach to get this:

   1. At first try I simply make data element of method, assign text as
   data value and count as aggregation type. On data entry, I entered
   'microscopy' or 'RDT'. Using this approach, the pivot table return only
   'microscopy'.
   [image: Inline images 2]

   2. I create Microscopy and RDT as category option and make it for
   disaggregation, create data element of method, assign yes only as data
   value and count as aggregation type. Using this, the pivot table do
   counting how many Microscopy and RDT but it doubled. I only entered 61
   value but pivot table give me 122 total.[image: Inline images 3]

   3. I create option set and define Miscroscopy and RDT then use it on
   method data element. The pivot table give me nothing.
   [image: Inline images 4]
   Also, the data value that I had been entered in data entry form is
   disappear. I thought it is not saved so I checked on postgres, but I found
   the data on postgres (using select * from datavalue). If that is the case,
   the data I had been entered should be there on the data entry form, isn't
   it?


This brings me to wonder, how does counting works in DHIS2? What is the
best solution for data that need to be counted? And why things I try above
is not working?

Any kind of help is really appreciated. Thank you very much.


Best regards,
Karina.