dhis2-users team mailing list archive

["Raminosoa Rabemanantsoa, Tantely" <traminosoa@xxxxxxxxxx>]

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" <lars@xxxxxxxxx> 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 <
> traminosoa@xxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> 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@xxxxxxxxx
> http://www.dhis2.org <https://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.*