Re: [Dhis2-users] [Dhis2-devs] Filtering Pivot Table Results (before Results Export)

[Raminosoa Rabemanantsoa, Tantely]

Hi Lars,

Thank you for this very clear instruction. It is straightforward and very
useful!

Regards,

Tantely.

Le 7 avr. 2017 6:25 PM, "Lars Helge Øverland"  a écrit :

>
> Hi Tantely,
>
> to achieve this I think you should use the "org unit group" selection
> mode. Under the organisation unit dimension section, click the gear icon
> and select "Select groups", then select the org unit group which contains
> the org units you would like to display.
>
> In the org unit tree you can leave the selected org unit at the national
> level if you would like to include facilities from the entire country.
>
>
> [image: Inline image 3]
>
>
> This will render the actual org units from that group in your pivot table.
>
> regards,
>
> Lars
>
>
>
>
>
> On Thu, Apr 6, 2017 at 5:38 PM, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear community,
>>
>> I am trying to create a filter to be used with the pivot table results,
>> so that only the filtered OrgUnits will appear. For that I have created
>> OrgUnit groups and have used them in the pivot table. The layout is
>> illustrated in the attached file, by using the OrgUnits in the row
>> dimensions. As a result, the pivot table is only using the OrgUnit groups
>> as a categorization of the results but not filtering them as all OrgUnits
>> are still displayed. I think that an interest using a filter is to avoid
>> dumping a huge amount of data, which is sometimes freezing DHIS2 when
>> displaying the results at the lowest level of OrgUnits.
>>
>> Which way should I follow in order to filter the OrgUnits according to
>> some criteria (like using a spreadsheet filter)? Would it be possible doing
>> that in the pivot table or it would be worth creating an equivalent SQL
>> uery? One constraint with using SQL View is that we can only call
>> DataElements but not Indicators.
>>
>> I am using DHIS2 2.24.
>>
>> Thank you for your support and suggestions!
>>
>> Regards,
>>
>> Tantely.
>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@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
> l...@dhis2.org
> http://www.dhis2.org 
>
>

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
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] [Dhis2-devs] Filtering Pivot Table Results (before Results Export)

[Lars Helge Øverland]

Hi Tantely,

to achieve this I think you should use the "org unit group" selection mode.
Under the organisation unit dimension section, click the gear icon and
select "Select groups", then select the org unit group which contains the
org units you would like to display.

In the org unit tree you can leave the selected org unit at the national
level if you would like to include facilities from the entire country.


[image: Inline image 3]


This will render the actual org units from that group in your pivot table.

regards,

Lars





On Thu, Apr 6, 2017 at 5:38 PM, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> Dear community,
>
> I am trying to create a filter to be used with the pivot table results, so
> that only the filtered OrgUnits will appear. For that I have created
> OrgUnit groups and have used them in the pivot table. The layout is
> illustrated in the attached file, by using the OrgUnits in the row
> dimensions. As a result, the pivot table is only using the OrgUnit groups
> as a categorization of the results but not filtering them as all OrgUnits
> are still displayed. I think that an interest using a filter is to avoid
> dumping a huge amount of data, which is sometimes freezing DHIS2 when
> displaying the results at the lowest level of OrgUnits.
>
> Which way should I follow in order to filter the OrgUnits according to
> some criteria (like using a spreadsheet filter)? Would it be possible doing
> that in the pivot table or it would be worth creating an equivalent SQL
> uery? One constraint with using SQL View is that we can only call
> DataElements but not Indicators.
>
> I am using DHIS2 2.24.
>
> Thank you for your support and suggestions!
>
> Regards,
>
> Tantely.
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@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
l...@dhis2.org
http://www.dhis2.org 
___
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