dhis2-users team mailing list archive

[Karina Dian Lestari <karinadnlstr@xxxxxxxxx>]

Hi Lars,

thank you for the suggestions! I will try this.


Best regards,
Karina

On 19 May 2016 at 19:31, Lars Helge Øverland <lars@xxxxxxxxx> wrote:

> 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/>
>
>