Filtering Pivot Table Results (before Results Export)

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.

Pivot_Table_Layout.pdf (120 KB)

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

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 traminosoa@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-devs@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

lars@dhis2.org

http://www.dhis2.org

Hi Lars,

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

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.

image

···

Le 7 avr. 2017 6:25 PM, “Lars Helge Øverland” lars@dhis2.org 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.

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 traminosoa@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-devs@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

lars@dhis2.org

http://www.dhis2.org