dhis2-users team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

Hi Karina,

thanks for reporting.

You should really use the program and events model for this type of survey
data. It is a lot more suitable for data capture and for data aggregation
according to various criteria.

- Create a program "without registration" (apps > programs and attributes).
- Click on the program, select view program stages and add your data
elements to the only program stage.
- Assign your program to your organisation units.
- Enter your surveys as events through the Event capture app.


You can now use both event reports and pivot table do analysis.

On event reports, all your data elements becomes dimensions for which you
can count events for each option in their option set.

You can also create program indicators (click on the program > program
indicators), where the filter can specify which types of data element
options you would like to include in the aggregation. The expression can be
set to event count (click the link under the expression area).

This can now be viewed in pivot table from Data > program indicators.

Program indicators docs here
<http://dhis2.github.io/dhis2-docs/master/en/user/html/ch31.html>.

regards,

Lars










On Wed, May 18, 2016 at 9:22 PM, Karina Dian Lestari <karinadnlstr@xxxxxxxxx
> wrote:

> 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.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx
http://www.dhis2.org <https://www.dhis2.org/>