Re: [Dhis2-users] Problem selecting all districts in orgunit hierarchy in pivot table module
Strange. Seems to work in the latest 2.12 at least. Please check if you can reproduce it here: http://apps.dhis2.org/demo/dhis-web-pivot/app/index.html . I recommend upgrading to the latest 2.12 anyway as it lets you select orgunits by boundaries/level in PT. I guess others can provide better use cases than I can, but one nice thing about having different kind of groups as dimensions is that if you 1) put them as the first dimension on Row, 2) put corresponding data elements/orgunits/etc as the second dimension on Row and 3) check hide empty rows in options, you will get nice grouping with subtotals like in Excel. Jan On Thu, Aug 29, 2013 at 9:03 AM, Wilson,Randy rwil...@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? ** ** ** ** 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. ** ** ** ** *Randy Wilson* ** ** ___ 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 image005.pngimage006.png___ 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
Re: [Dhis2-users] Problem selecting all districts in orgunit hierarchy in pivot table module
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 linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16 On 29 August 2013 12:00, Lars Helge Øverland larshe...@gmail.com wrote: Hi Randy, On Thu, Aug 29, 2013 at 9:03 AM, Wilson,Randy rwil...@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 ___ 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 image005.pngimage006.png___ 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
Re: [Dhis2-users] Problem selecting all districts in orgunit hierarchy in pivot table module
Hi Lars, It seems to work in Mozilla, but not in Chrome, so I'll go back to that browser again. Also thanks for explaining the use of dataelement group sets. We are clearly not using them that way... and should probably work out the naming conventions if we wanted to. Seems like a good idea. Thanks, Randy From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: Thursday, August 29, 2013 12:01 PM To: Wilson,Randy Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Problem selecting all districts in orgunit hierarchy in pivot table module Hi Randy, On Thu, Aug 29, 2013 at 9:03 AM, Wilson,Randy rwil...@msh.orgmailto:rwil...@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? [cid:image001.png@01CEA4C4.333FFD60] 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. [cid:image002.png@01CEA4C4.333FFD60] 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 inline: image001.pnginline: image002.png___ 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
Re: [Dhis2-users] Problem selecting all districts in orgunit hierarchy in pivot table module
This has something to do with the version of Chrome or Mozilla you are using, Since they keep automatically updating with Chrome Version 29.0.1547.57 m And Mozilla latest version the scrolling is fine On Thu, Aug 29, 2013 at 1:30 PM, Ola Hodne Titlestad ol...@ifi.uio.nowrote: 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 linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16 On 29 August 2013 12:00, Lars Helge Øverland larshe...@gmail.com wrote: Hi Randy, On Thu, Aug 29, 2013 at 9:03 AM, Wilson,Randy rwil...@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 ___ 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 ___ 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 -- Prosper Behumbiize, MPH Phone:+256 414 320076 Cell:+256 752 751776 +256 702 762707 image006.pngimage005.png___ 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