dhis2-users team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

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<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge&hl=en&ie=UTF8&sll=59.893855,10.785116&sspn=0.222842,0.585709&oq=eftas%C3%A5sen+68,+0687+Oslo,+&t=h&hnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway&z=16>


On 29 August 2013 12:00, Lars Helge Øverland <larshelge@xxxxxxxxx> wrote:

> Hi Randy,
>
>
> On Thu, Aug 29, 2013 at 9:03 AM, Wilson,Randy <rwilson@xxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>