Pivot table data reporting

Dear all,

We are using dhis2 , 2.18 for a hospital information system.
Data element for theater statistics developed by using category combination of , Gender( M,F,Not define) and Type of surgery(Major, minor, intermediate).

I need to get report on total for each category as follows,

eg.

Major

Intermediate

Minor

No of general surgeries

No of Plastic surgeries

Is it possible to get such report in pivot table or any other reporting within dhis2?

Regards,

Dr.Sumudu Weerasinghe

Medical officer Health informatics

Teaching hospital - Ragama

Srin Lanka

Hi Sumudu,

yes there are two options:

  1. You can go to the data items > data elements section, the for data elements you select “Details” instead of “Totals”

image

  1. You can make sure your category is marked as a “Data dimension” in the maintenance (make sure to re-run analytics afterwards if you changed it).

You can then use the category in your pivot (from the left side panel), select your items and place the dimension on the “rows” from the Layout dialog.

regards,

Lars

···

On Sat, Aug 15, 2015 at 8:25 AM, sumudu weerasinghe sumuduw00@gmail.com wrote:

Dear all,

We are using dhis2 , 2.18 for a hospital information system.
Data element for theater statistics developed by using category combination of , Gender( M,F,Not define) and Type of surgery(Major, minor, intermediate).

I need to get report on total for each category as follows,

eg.

Major

Intermediate

Minor

No of general surgeries

No of Plastic surgeries

Is it possible to get such report in pivot table or any other reporting within dhis2?

Regards,

Dr.Sumudu Weerasinghe

Medical officer Health informatics

Teaching hospital - Ragama

Srin Lanka


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Thanks Lars,

I tried in two ways but unable to gain my need ,

1.st Method, it gives subdivision into gender , i need total of all gender category, without .
Inline image 2

2 nd method , also unable to give solution , giving same result as above.

What i need is eg.

  1. no of plastic surgeries (Minor)— not gender wise categorization

Can we get it through dhis2?

Regards

Sumudu

image

···

On Sat, Aug 15, 2015 at 4:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Sumudu,

yes there are two options:

  1. You can go to the data items > data elements section, the for data elements you select “Details” instead of “Totals”
  1. You can make sure your category is marked as a “Data dimension” in the maintenance (make sure to re-run analytics afterwards if you changed it).

You can then use the category in your pivot (from the left side panel), select your items and place the dimension on the “rows” from the Layout dialog.

regards,

Lars

On Sat, Aug 15, 2015 at 8:25 AM, sumudu weerasinghe sumuduw00@gmail.com wrote:

Dear all,

We are using dhis2 , 2.18 for a hospital information system.
Data element for theater statistics developed by using category combination of , Gender( M,F,Not define) and Type of surgery(Major, minor, intermediate).

I need to get report on total for each category as follows,

eg.

Major

Intermediate

Minor

No of general surgeries

No of Plastic surgeries

Is it possible to get such report in pivot table or any other reporting within dhis2?

Regards,

Dr.Sumudu Weerasinghe

Medical officer Health informatics

Teaching hospital - Ragama

Srin Lanka


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Dear Sumudu,

Method 2 should work. Note that you cannot use the data elements details option then. You will get your ‘type of surgery’ disaggregation as a separate dimension in analytics that you can see appearing as a new menu item in the left side menu and that you can put on columns in the layout selection. Then select your data elements as before, but in ‘total’ mode, not details. Put data elements on rows. The gender dimension you don’t touch as you want all of those collapsed.

Ola

image

image

···

On Sat, Aug 15, 2015 at 4:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Sumudu,

yes there are two options:

  1. You can go to the data items > data elements section, the for data elements you select “Details” instead of “Totals”
  1. You can make sure your category is marked as a “Data dimension” in the maintenance (make sure to re-run analytics afterwards if you changed it).

You can then use the category in your pivot (from the left side panel), select your items and place the dimension on the “rows” from the Layout dialog.

regards,

Lars

On Sat, Aug 15, 2015 at 8:25 AM, sumudu weerasinghe sumuduw00@gmail.com wrote:

Dear all,

We are using dhis2 , 2.18 for a hospital information system.
Data element for theater statistics developed by using category combination of , Gender( M,F,Not define) and Type of surgery(Major, minor, intermediate).

I need to get report on total for each category as follows,

eg.

Major

Intermediate

Minor

No of general surgeries

No of Plastic surgeries

Is it possible to get such report in pivot table or any other reporting within dhis2?

Regards,

Dr.Sumudu Weerasinghe

Medical officer Health informatics

Teaching hospital - Ragama

Srin Lanka


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Thanks Ola and Lars,

Yes it is working now . Earlier it was not select as data dimension .

Regards

Sumudu

image

image

···

On Wed, Aug 19, 2015 at 11:16 AM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Dear Sumudu,

Method 2 should work. Note that you cannot use the data elements details option then. You will get your ‘type of surgery’ disaggregation as a separate dimension in analytics that you can see appearing as a new menu item in the left side menu and that you can put on columns in the layout selection. Then select your data elements as before, but in ‘total’ mode, not details. Put data elements on rows. The gender dimension you don’t touch as you want all of those collapsed.

Ola


On 16 Aug 2015 4:53 pm, “sumudu weerasinghe” sumuduw00@gmail.com wrote:

Thanks Lars,

I tried in two ways but unable to gain my need ,

1.st Method, it gives subdivision into gender , i need total of all gender category, without .

2 nd method , also unable to give solution , giving same result as above.

What i need is eg.

  1. no of plastic surgeries (Minor)— not gender wise categorization

Can we get it through dhis2?

Regards

Sumudu


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Sat, Aug 15, 2015 at 4:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Sumudu,

yes there are two options:

  1. You can go to the data items > data elements section, the for data elements you select “Details” instead of “Totals”
  1. You can make sure your category is marked as a “Data dimension” in the maintenance (make sure to re-run analytics afterwards if you changed it).

You can then use the category in your pivot (from the left side panel), select your items and place the dimension on the “rows” from the Layout dialog.

regards,

Lars

On Sat, Aug 15, 2015 at 8:25 AM, sumudu weerasinghe sumuduw00@gmail.com wrote:

Dear all,

We are using dhis2 , 2.18 for a hospital information system.
Data element for theater statistics developed by using category combination of , Gender( M,F,Not define) and Type of surgery(Major, minor, intermediate).

I need to get report on total for each category as follows,

eg.

Major

Intermediate

Minor

No of general surgeries

No of Plastic surgeries

Is it possible to get such report in pivot table or any other reporting within dhis2?

Regards,

Dr.Sumudu Weerasinghe

Medical officer Health informatics

Teaching hospital - Ragama

Srin Lanka


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org