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.overl...@gmail.com> 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 <ptb3...@gmail.com> 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@lists.launchpad.net >> 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
Reporting rates.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
_______________________________________________ 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