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?
You can go to the data items > data elements section, the for data elements you select “Details” instead of “Totals”
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?
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.
no of plastic surgeries (Minor)— not gender wise categorization
Can we get it through dhis2?
Regards
Sumudu
···
On Sat, Aug 15, 2015 at 4:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:
Hi Sumudu,
yes there are two options:
You can go to the data items > data elements section, the for data elements you select “Details” instead of “Totals”
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?
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 Sat, Aug 15, 2015 at 4:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:
Hi Sumudu,
yes there are two options:
You can go to the data items > data elements section, the for data elements you select “Details” instead of “Totals”
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?
Yes it is working now . Earlier it was not select as data dimension .
Regards
Sumudu
···
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.
On Sat, Aug 15, 2015 at 4:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:
Hi Sumudu,
yes there are two options:
You can go to the data items > data elements section, the for data elements you select “Details” instead of “Totals”
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?
