Hi Randy,
There are actually quite a few use cases for aggregation along data element groups.
But this of course depends on how you design data elements, categories, and groups, especially how much you have used categories.
Sometimes there are dimensions to the data elements that you want to add after data entry (shared characteristics across certain data elements) and then groups can be very useful for doing aggregations along these.
Here’s an example of how you can use data element groups for aggregation:
http://tracker.dhis2.org/dhis-web-pivot/app/index.html?id=WCO0fV45zdv
(same login as with the online demo) - you’ll see that the Data dimension is not used at all in this pivot table, but instead data is aggregated and visualised by groups.
I also find it useful to have groups in pivot tables for ordering purpose, to e.g. list all Child Health data element on rows, but sorted by their groups (sub-programs like Immunisation and Nutrition), like this example:
http://tracker.dhis2.org/dhis-web-pivot/app/index.html?id=SflhID5ZObb
(If you open Options you’ll notice that I have used the option “hide empty rows”).
Ola
···
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
On 29 August 2013 12:00, Lars Helge Øverland larshelge@gmail.com wrote:
Hi Randy,
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
On Thu, Aug 29, 2013 at 9:03 AM, Wilson,Randy rwilson@msh.org wrote:
I think I may have seen something related to this before but can’t seem to get it to work. When I want to select all of the districts from the orgunit hierarchy for a pivot table, I can select any that are visible, but the remaining districts in Western province are not visible (off the screen). I cannot scroll below Muhanga District. I have tried zooming out the page, but nothing seems to work. Has this been fixed in a newer release of 2.12?
I have actually seen this a few times on Windows - never on Mac or Linux. I suspect it is a bug with the javascript library we using (Ext JS) but we will try to look into it more closely and see what we can do.
While I’m at it, why do the data element group sets appear in the list of dimensions in the pivot table dialog? It makes sense to have orgunit group sets like “admin unit type”, “ownership”, but the “Malaria_all” data element group set and the “thematic area” data element group set? I can’t see any use case for making them dimensions in the pivot table.
As you know, categories, org unit group sets and data element group sets can be used as dynamic data dimensions in DHIS. For the categories you can select explicitly which ones should appear as data dimensions (in pivot, visualizer etc). We figured that most group sets would make sense as data dimensions - but that assumption might be wrong and we could easily add an option for picking which group sets should appear as dimensions. Let us know.
I am not sure how your “Malaria all” group set is defined, but ideally a group set should be suitable as data dimension - for instance it could give you the totals of groups of malaria-related data elements.
regards,
Lars