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
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@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
Thanks Jan,
This works but when you export the bank rows appear
Regards
On Thu, Sep 26, 2013 at 1:27 PM, Jan Henrik Øverland janhenrik.overland@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
–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 752 751776
+256 702 762707
On Wed, Sep 25, 2013 at 4:08 PM, Prosper BT ptb3000@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 320076Cell: +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
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
Reporting rates.xlsx (18.2 KB)
On Thu, Sep 26, 2013 at 1:27 PM, Jan Henrik Øverland janhenrik.overland@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
–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 752 751776
+256 702 762707
On Wed, Sep 25, 2013 at 4:08 PM, Prosper BT ptb3000@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 320076Cell: +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
Another requirment.
With list attached, will 2.13 be able to include columns of parent Orgunit, its more friendly to have the parent orgunit listed along for easy follow up.
The national team we are training this week want to follow up facilities without reports and when they run such a list at facilities level it would be easy if they can see the districts they are from.
Regards
On Wed, Oct 2, 2013 at 5:53 PM, Prosper BT ptb3000@gmail.com wrote:
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
–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 752 751776
+256 702 762707
On Thu, Sep 26, 2013 at 1:27 PM, Jan Henrik Øverland janhenrik.overland@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
–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 752 751776
+256 702 762707
On Wed, Sep 25, 2013 at 4:08 PM, Prosper BT ptb3000@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 320076Cell: +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
Hi Prosper, yes we plan to include the hierarchy information for facilities in pivot table for 2.13.
cheers
Lars
On Wed, Oct 2, 2013 at 4:58 PM, Prosper BT ptb3000@gmail.com wrote:
Another requirment.
With list attached, will 2.13 be able to include columns of parent Orgunit, its more friendly to have the parent orgunit listed along for easy follow up.
The national team we are training this week want to follow up facilities without reports and when they run such a list at facilities level it would be easy if they can see the districts they are from.
Regards
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
On Wed, Oct 2, 2013 at 5:53 PM, Prosper BT ptb3000@gmail.com wrote:
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
–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 752 751776
+256 702 762707
On Thu, Sep 26, 2013 at 1:27 PM, Jan Henrik Øverland janhenrik.overland@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
–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 752 751776
+256 702 762707
On Wed, Sep 25, 2013 at 4:08 PM, Prosper BT ptb3000@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 320076Cell: +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
Great Lars, looking forward.
The team was appreciative of the functionalities.
What about rates above 100% for reporting rates?
Regards
On Wed, Oct 2, 2013 at 6:08 PM, Lars Helge Øverland larshelge@gmail.com wrote:
Hi Prosper, yes we plan to include the hierarchy information for facilities in pivot table for 2.13.
cheers
Lars
–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 752 751776
+256 702 762707
On Wed, Oct 2, 2013 at 4:58 PM, Prosper BT ptb3000@gmail.com wrote:
Another requirment.
With list attached, will 2.13 be able to include columns of parent Orgunit, its more friendly to have the parent orgunit listed along for easy follow up.
The national team we are training this week want to follow up facilities without reports and when they run such a list at facilities level it would be easy if they can see the districts they are from.
Regards
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
On Wed, Oct 2, 2013 at 5:53 PM, Prosper BT ptb3000@gmail.com wrote:
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
–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 752 751776
+256 702 762707
On Thu, Sep 26, 2013 at 1:27 PM, Jan Henrik Øverland janhenrik.overland@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
–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 752 751776
+256 702 762707
On Wed, Sep 25, 2013 at 4:08 PM, Prosper BT ptb3000@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 320076Cell: +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
Great Lars, looking forward.
The team was appreciative of the functionalities.
Thanks.
What about rates above 100% for reporting rates?
Could you elaborate a bit here..? Do you mean the possibility for filtering
data on particular dimensions?
On Wed, Oct 2, 2013 at 5:21 PM, Prosper BT <ptb3000@gmail.com> wrote:
Sorry Lars,
When we run reporting rates in both Pivot tables and Visualizer, we get percentage above 100% meaning that they are more facilities reporting on a given dataset than then ones assigned to.
Se this report below
HMIS 105:1
Oct-12
Nov-12
Dec-12
Jan-13
Feb-13
Mar-13
Apr-13
May-13
Jun-13
Jul-13
Aug-13
Sep-13
Butambala District
108.7
100
100
100
100
100
100
100
100
100
100
Kalangala District
100
100
118.2
127.3
127.3
118.2
127.3
109.1
109.1
100
100
Kamwenge District
105.6
105.6
105.6
105.6
102.8
105.6
100
105.6
105.6
102.8
102.8
On Thu, Oct 3, 2013 at 9:29 AM, Lars Helge Øverland larshelge@gmail.com wrote:
–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 752 751776
+256 702 762707
On Wed, Oct 2, 2013 at 5:21 PM, Prosper BT ptb3000@gmail.com wrote:
Great Lars, looking forward.
The team was appreciative of the functionalities.
Thanks.
What about rates above 100% for reporting rates?
Could you elaborate a bit here…? Do you mean the possibility for filtering data on particular dimensions?