← Back to team overview

dhis2-devs team mailing list archive

Re: Filtering by OrgUnit groups, Type

 

Hi Jan

Thanks this worked though but as I mentioned the hidden raws appear when
you export.

Team and wanted to find the best reason for more than 100$ reporting rates
its been disturbing the team and I seem not to get the exact reason behind
this.

See attached output

Regards


On Thu, Sep 26, 2013 at 1:27 PM, Jan Henrik Øverland <
janhenrik.overland@xxxxxxxxx> wrote:

> Hi Prosper,
>
> as you say, orgunit selection by group will be available in 2.13. However,
> there is a way to select all orgunits in a group at a particular level in
> 2.12. Try the following (pivot table):
>
> - Select a couple of indicators or data elements.
> - Go to the *organisation units* panel and change the selection mode to *select
> boundaries and level*. Select your facility level in the combobox and
> then the root orgunit in the tree.
> - Go to the *type* panel and select e.g. *CHC.*
> - Go to the *periods* panel and select *last 3 months*.
>
> - Open the *layout* window from the toolbar and put 1) *periods* on
> filter 2) *type* and *organisation units* on row (in that order)  3) *data
> * on column.
> - Open the *options* window from the toolbar and select *hide empty rows*.
>
> Click update and you should see a list of CHC facilities only (that have
> values for this data/period combination).
>
> PS: If Uganda have about 8000 facilities the request is likely to be
> rejected by the server, so you might have to use the tree and narrow it
> down to regions or even districts.
>
> Jan
>
>
> On Wed, Sep 25, 2013 at 4:08 PM, Prosper BT <ptb3000@xxxxxxxxx> wrote:
>
>> Hi Team,
>>
>> With 2.12 am faced with the challenge of line listing data based on
>> OrgUnit group filtering by Orgunit group sets.
>>
>> With report tables we were able to toggle and select facilities based on
>> groups but you only implemented selection by level and not groups and even
>> type.
>>
>> I can see it 2.13
>>
>>
>> --
>> Prosper Behumbiize, MPH
>> Phone:        +256 414 320076
>> Cell:            +256 752 751776
>>                    +256 702 762707
>>
>> _______________________________________________
>> 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
>>
>>
>


-- 
Prosper Behumbiize, MPH
Phone:        +256 414 320076
Cell:            +256 752 751776
                   +256 702 762707

Attachment: Reporting rates.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Follow ups

References