Count aggregation type

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

  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

  3. I create option set and define Miscroscopy and RDT then use it on method data element. The pivot table give me nothing.
    image
    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.

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.

regards,

Lars

···

On Wed, May 18, 2016 at 9:22 PM, Karina Dian Lestari karinadnlstr@gmail.com 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’.

  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.

  3. I create option set and define Miscroscopy and RDT then use it on method data element. The pivot table give me nothing.

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@lists.launchpad.net

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@dhis2.org

http://www.dhis2.org

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@dhis2.org 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.

regards,

Lars

On Wed, May 18, 2016 at 9:22 PM, Karina Dian Lestari karinadnlstr@gmail.com 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’.

  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.

  3. I create option set and define Miscroscopy and RDT then use it on method data element. The pivot table give me nothing.

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@lists.launchpad.net

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@dhis2.org

http://www.dhis2.org