[Dhis2-devs] DHIS-2 Report issues

Hi Randy,
On your issue with data completeness report ,you can get a report of defaulting orgunits(Facilities I guess) by selecting the next aggregation level to your facilities as your default Org unit in your defining parameters . This report shows the selected org unit as well as all children under that unit.
I agree this is not a straight forward method as it looks like the data completeness report was primarily designed to give overviews of gross completeness reports rather than 'individual' focused reporting. There might be a need for improvement in future builds on this but you can still work with what we have now to get what you want.

Dapo

···

----- Original Message -----
From: "Jason Pickering" <jason.p.pickering@gmail.com>
To: "Randy Wilson" <rwilson@msh.org>
Cc: dhis2-users@lists.launchpad.net, "dhis2-devs" <dhis2-devs@lists.launchpad.net>
Sent: Wednesday, 21 March, 2012 8:25:22 AM
Subject: Re: [Dhis2-devs] [Dhis2-users] DHIS-2 Report issues

Hi Randy,

How about using a custom report? There is a quite good section in the
implementers manual on how to use iReport.

Best regards,
Jason

On Wed, Mar 21, 2012 at 9:14 AM, Wilson,Randy <rwilson@msh.org> wrote:

Hi all,

The Rwanda team now has 3 months of data from over 400 sites in the DHIS-2.
We’re impressed with how well it has worked even in low bandwidth
conditions. Congratulations to the team who built in the offline editing
functionality.

Now we’re on to reporting and find a number of immediate concerns:

1. Data completeness report: There does not seem to be a report that
lists the orgunits that did not report for a given period for a given
dataset. We need this to issue reminders to data managers and their
district supervisors so that data entry is complete.

2. When we create a report-table for any data elements in a data set
and list leaf orgunits, it lists all orgunits at that level regardless of
whether or not they are supposed to report for that dataset. In Rwanda we
have health facilities and a number of administrative units (Health
Insurance offices) at the same orgunit level and we can’t filter out the
latter. There also does not appear to be a way to include frequently used
orgunitgroups like type (health center, hospital, referral hospital, etc…)
or ownership in the filter criteria for these report tables.

Any suggestions would be very helpful.

Randy Wilson

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

_______________________________________________
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 Randy,

Thanks for the useful feedback on reporting. I think we should try to both improve reporting rate listing for the lowest level and include more orgunit filters in report tables. I would prefer we try to expand report table functionality rather than advocating for use of custom datasources with iReoport. The default template for iReport generated off a specific report table makes it so much easier to use iReport.

One possible quick fix for listing all leaf nodes that were supposed to report, but still haven’t is to make a report table where you select the dataset you need and make sure it is crosstabbed. Then leave period and orgunits non-crosstabbed. Select reporting months in both periods and parameter and select leaf orgunits in parameter. The report table will then display the completeness percentage for all orgunits at the lowest level. There are three possible values; 100 for those who have reported, 0 for those that have still not reported, and blank/NULL for those that are not supposed to report(not assigned to that dataset). In iReport you can filter which rows to display based on that field, so e.g. just list all facilities that still haven’t reported. Haven’t done exactly this before, but pretty sure you can do this filtering in iReport.

In the meantime we will work on improving the generic tools to meet your requirements, which seem very reasonable.

Ola

···

On Mar 21, 2012 10:50 AM, “Dapo Adejumo” dapo_adejumo@yahoo.com wrote:

Hi Randy,

On your issue with data completeness report ,you can get a report of defaulting orgunits(Facilities I guess) by selecting the next aggregation level to your facilities as your default Org unit in your defining parameters . This report shows the selected org unit as well as all children under that unit.

I agree this is not a straight forward method as it looks like the data completeness report was primarily designed to give overviews of gross completeness reports rather than ‘individual’ focused reporting. There might be a need for improvement in future builds on this but you can still work with what we have now to get what you want.

Dapo

----- Original Message -----

From: “Jason Pickering” jason.p.pickering@gmail.com

To: “Randy Wilson” rwilson@msh.org

Cc: dhis2-users@lists.launchpad.net, “dhis2-devs” dhis2-devs@lists.launchpad.net

Sent: Wednesday, 21 March, 2012 8:25:22 AM

Subject: Re: [Dhis2-devs] [Dhis2-users] DHIS-2 Report issues

Hi Randy,

How about using a custom report? There is a quite good section in the

implementers manual on how to use iReport.

Best regards,

Jason

On Wed, Mar 21, 2012 at 9:14 AM, Wilson,Randy rwilson@msh.org wrote:

Hi all,

The Rwanda team now has 3 months of data from over 400 sites in the DHIS-2.

We’re impressed with how well it has worked even in low bandwidth

conditions. Congratulations to the team who built in the offline editing

functionality.

Now we’re on to reporting and find a number of immediate concerns:

  1.   Data completeness report: There does not seem to be a report that
    

lists the orgunits that did not report for a given period for a given

dataset. We need this to issue reminders to data managers and their

district supervisors so that data entry is complete.

  1.   When we create a report-table for any data elements in a data set
    

and list leaf orgunits, it lists all orgunits at that level regardless of

whether or not they are supposed to report for that dataset. In Rwanda we

have health facilities and a number of administrative units (Health

Insurance offices) at the same orgunit level and we can’t filter out the

latter. There also does not appear to be a way to include frequently used

orgunitgroups like type (health center, hospital, referral hospital, etc…)

or ownership in the filter criteria for these report tables.

Any suggestions would be very helpful.

Randy Wilson


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Thanks for this workaround on the reporting completion. I’ll try it.

Another question came up today as we are working on the data visualizer:

My understanding was that if you create a chart as a superuser and save it as a favorite with the system checkbox checked, it should be visible for other users. We’ve tested it and that doesn’t seem to work.

We’d like to create re-useable charts that different users can use in their dashboards, so the system option would be very useful. The same functionality should be available for GIS favorites.

We’re using Version 2.7.

Randy Wilson

···

From: dhis2-users-bounces+rwilson=msh.org@lists.launchpad.net [mailto:dhis2-users-bounces+rwilson=msh.org@lists.launchpad.net] On Behalf Of Ola Hodne Titlestad
Sent: Wednesday, March 21, 2012 12:24 PM
To: Dapo Adejumo
Cc: dhis2-users@lists.launchpad.net; dhis2-devs
Subject: Re: [Dhis2-users] [Dhis2-devs] DHIS-2 Report issues

Hi Randy,
Thanks for the useful feedback on reporting. I think we should try to both improve reporting rate listing for the lowest level and include more orgunit filters in report tables. I would prefer we try to expand report table functionality rather than advocating for use of custom datasources with iReoport. The default template for iReport generated off a specific report table makes it so much easier to use iReport.

One possible quick fix for listing all leaf nodes that were supposed to report, but still haven’t is to make a report table where you select the dataset you need and make sure it is crosstabbed. Then leave period and orgunits non-crosstabbed. Select reporting months in both periods and parameter and select leaf orgunits in parameter. The report table will then display the completeness percentage for all orgunits at the lowest level. There are three possible values; 100 for those who have reported, 0 for those that have still not reported, and blank/NULL for those that are not supposed to report(not assigned to that dataset). In iReport you can filter which rows to display based on that field, so e.g. just list all facilities that still haven’t reported. Haven’t done exactly this before, but pretty sure you can do this filtering in iReport.

In the meantime we will work on improving the generic tools to meet your requirements, which seem very reasonable.

Ola

On Mar 21, 2012 10:50 AM, “Dapo Adejumo” dapo_adejumo@yahoo.com wrote:

Hi Randy,
On your issue with data completeness report ,you can get a report of defaulting orgunits(Facilities I guess) by selecting the next aggregation level to your facilities as your default Org unit in your defining parameters . This report shows the selected org unit as well as all children under that unit.
I agree this is not a straight forward method as it looks like the data completeness report was primarily designed to give overviews of gross completeness reports rather than ‘individual’ focused reporting. There might be a need for improvement in future builds on this but you can still work with what we have now to get what you want.

Dapo

----- Original Message -----
From: “Jason Pickering” jason.p.pickering@gmail.com
To: “Randy Wilson” rwilson@msh.org
Cc: dhis2-users@lists.launchpad.net, “dhis2-devs” dhis2-devs@lists.launchpad.net
Sent: Wednesday, 21 March, 2012 8:25:22 AM
Subject: Re: [Dhis2-devs] [Dhis2-users] DHIS-2 Report issues

Hi Randy,

How about using a custom report? There is a quite good section in the
implementers manual on how to use iReport.

Best regards,
Jason

On Wed, Mar 21, 2012 at 9:14 AM, Wilson,Randy rwilson@msh.org wrote:

Hi all,

The Rwanda team now has 3 months of data from over 400 sites in the DHIS-2.
We’re impressed with how well it has worked even in low bandwidth
conditions. Congratulations to the team who built in the offline editing
functionality.

Now we’re on to reporting and find a number of immediate concerns:

  1.   Data completeness report: There does not seem to be a report that
    

lists the orgunits that did not report for a given period for a given
dataset. We need this to issue reminders to data managers and their
district supervisors so that data entry is complete.

  1.   When we create a report-table for any data elements in a data set
    

and list leaf orgunits, it lists all orgunits at that level regardless of
whether or not they are supposed to report for that dataset. In Rwanda we
have health facilities and a number of administrative units (Health
Insurance offices) at the same orgunit level and we can’t filter out the
latter. There also does not appear to be a way to include frequently used
orgunitgroups like type (health center, hospital, referral hospital, etc…)
or ownership in the filter criteria for these report tables.

Any suggestions would be very helpful.

Randy Wilson


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp


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


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

My understanding was that if you create a chart as a superuser and save it
as a favorite with the system checkbox checked, it should be visible for
other users. We’ve tested it and that doesn’t seem to work.

We’d like to create re-useable charts that different users can use in their
dashboards, so the system option would be very useful. The same
functionality should be available for GIS favorites.

Hi Randy, this should work. I tested now on you system, created a
chart "ANC Visits and Tests" with the "system" box checked. Then
created and logged in as a non-privileged user (removed now).

In dashboard I can select that chart from the "insert" link above the
chart areas. In data visualizer I can load that chart from the
"favorites" menu option.

regards, Lars