DHIS Annual Report

Dear;

Dear DHIS2 Users;

I am using DHIS2 in
managing community health data in our organization (CDC funded). I am now
supposed to produce an annual report for which the financial year ends in
September 31. How can I go about it.

Regards

Muhumuza Kananura Rornald

Management Information System Officer

THETA Uganda

tel: 0776301718

Hello Muhumuza,

at the moment we only support aggregated reports for the financial
year which starts in July. We can implement support for this in the
next version which is 2.10.

The work-around is to create a "report table" (reports module) where
you include the four quarters which comprise your financial year. You
then generate this report and export to Excel where you can summarize
those four quarters into the financial year.

regards,

Lars

···

On Mon, Sep 10, 2012 at 2:10 PM, Muhumuza Kananura Rornald <mk.rornald@yahoo.com> wrote:

Dear;

Dear DHIS2 Users;
I am using DHIS2 in managing community health data in our organization (CDC
funded). I am now supposed to produce an annual report for which the
financial year ends in September 31. How can I go about it.

Regards

Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda
tel: 0776301718

_______________________________________________
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

Dear Lars;
Thanks for the support.
I have data entrants who are paid according the number of forms (Data sets) entered. Is there any way how I can access the number of forms submitted by each individual.

I will be grateful for the feedback.

Regards
Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda
Tel: +256776301718

···

From: Lars Helge Øverland larshelge@gmail.com
To: Muhumuza Kananura Rornald mk.rornald@yahoo.com
Cc: "dhis2-users@lists.launchpad.net" dhis2-users@lists.launchpad.net
Sent: Tuesday, September 11, 2012 2:12 PM
Subject: Re: [Dhis2-users] DHIS Annual Report

Hello Muhumuza,

at the moment we only support aggregated reports for the financial
year which starts in July. We can implement support for this in the
next version which is 2.10.

The work-around is to create a “report table” (reports module) where
you include the four quarters which comprise your financial year. You
then generate this report and export to Excel where you can summarize
those four quarters into the financial year.

regards,

Lars

On Mon, Sep 10, 2012 at 2:10 PM, Muhumuza Kananura Rornald > mk.rornald@yahoo.com wrote:

Dear;

Dear DHIS2 Users;
I am using DHIS2 in managing community health data in our organization (CDC
funded). I am now supposed to produce an annual report for which the
financial year ends in September 31. How can I go about it.

Regards

Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda
tel: 0776301718


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

Dear Lars;
Thanks for the support.
I have data entrants who are paid according the number of forms (Data sets) entered. Is there any way
how I can access the number of forms submitted by each individual.

I will be grateful for the feedback.

Regards
Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda
Tel: +256776301718

···

From: Muhumuza Kananura Rornald mk.rornald@yahoo.com
To: Lars Helge Øverland larshelge@gmail.com
Cc: "dhis2-users@lists.launchpad.net" dhis2-users@lists.launchpad.net

Sent: Tuesday, September 11, 2012 4:07 PM
Subject: Re: [Dhis2-users] DHIS Annual Report

Dear Lars;
Thanks for the support.
I have data entrants who are paid according the number of forms (Data sets) entered. Is there any way how I can access the number of forms submitted by each individual.

I will be grateful for the feedback.

Regards
Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda
Tel: +256776301718


From: Lars Helge Øverland
larshelge@gmail.com
To: Muhumuza Kananura Rornald mk.rornald@yahoo.com
Cc: "dhis2-users@lists.launchpad.net" dhis2-users@lists.launchpad.net
Sent: Tuesday, September 11, 2012 2:12 PM
Subject: Re: [Dhis2-users] DHIS Annual Report

Hello Muhumuza,

at the moment we only support aggregated reports for the financial
year which starts in July. We can implement support for this in the
next version which is 2.10.

The work-around is to create a “report table” (reports module) where
you include the four quarters which comprise your financial year. You
then generate this report and export to Excel where you can summarize
those four quarters into the financial year.

regards,

Lars

On Mon, Sep 10, 2012 at 2:10 PM, Muhumuza Kananura Rornald > > mk.rornald@yahoo.com wrote:

Dear;

Dear DHIS2 Users;
I am using DHIS2 in managing community health data in our organization (CDC
funded). I am now supposed to produce an annual report for which the
financial year ends in September 31. How can I go about it.

Regards

Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda
tel: 0776301718


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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

There is no way to get this directly. You would need to look in the completedatasetregistration table.

However, if you have multiple people who might submit the data for a particular orgunit, you would not be able to distinguish who completed the information the first time, versus the last time. The only thing this table will show you will be the last person who “completed” the data.

I think

SELECT storedby, COUNT(*) FROM completedatasetregistration

WHERE date >= ‘2011-10-01’ and date <=‘2012-09-30’

GROUP BY storedby;

might give you what you need however.

Regards,

Jason

···

On Tue, Sep 11, 2012 at 6:37 PM, Muhumuza Kananura Rornald mk.rornald@yahoo.com wrote:

Dear Lars;
Thanks for the support.

I have data entrants who are paid according the number of forms (Data sets) entered. Is there any way how I can access the number of forms submitted by each individual.

I will be grateful for the feedback.

Regards
Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda

Tel: +256776301718


From: Lars Helge Øverland larshelge@gmail.com
To: Muhumuza Kananura Rornald mk.rornald@yahoo.com

Cc:dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.net

Sent: Tuesday, September 11, 2012 2:12 PM
Subject: Re: [Dhis2-users] DHIS Annual Report

Hello Muhumuza,

at the moment we only support aggregated reports for the financial
year which starts in July. We can implement support for this in the
next version which is 2.10.

The work-around is to create a “report table” (reports module) where

you include the four quarters which comprise your financial year. You
then generate this report and export to Excel where you can summarize
those four quarters into the financial year.

regards,

Lars

On Mon, Sep 10, 2012 at 2:10 PM, Muhumuza Kananura Rornald > > mk.rornald@yahoo.com wrote:

Dear;

Dear DHIS2 Users;
I am using DHIS2 in managing community health data in our organization (CDC

funded). I am now supposed to produce an annual report for which the
financial year ends in September 31. How can I go about it.

Regards

Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda
tel: 0776301718


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-users

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

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

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

Yes, you can teach the data entrants to use the "complete" button at
the end of each form after they have filled it properly. You can then
later use the "Reporting rate summary" tool in reports module to
assess the number of forms completed. To double check whether the
forms are actually filled you can define a set of "compulsory data
elements" (click on the yellow icon next to the data set in the data
set list). Then later in reporting rate summary you can choose "Based
on compulsory data elements" as method for calculating form
submissions - a form is considered complete if values are entered for
all compulsory data elements.

···

On Tue, Sep 11, 2012 at 3:14 PM, Muhumuza Kananura Rornald <mk.rornald@yahoo.com> wrote:

Dear Lars;
Thanks for the support.
I have data entrants who are paid according the number of forms (Data sets)
entered. Is there any way how I can access the number of forms submitted by
each individual.

I will be grateful for the feedback.

Regards
Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda
Tel: +256776301718

________________________________
From: Muhumuza Kananura Rornald <mk.rornald@yahoo.com>
To: Lars Helge Øverland <larshelge@gmail.com>
Cc: "dhis2-users@lists.launchpad.net" <dhis2-users@lists.launchpad.net>
Sent: Tuesday, September 11, 2012 4:07 PM
Subject: Re: [Dhis2-users] DHIS Annual Report

Dear Lars;
Thanks for the support.
I have data entrants who are paid according the number of forms (Data sets)
entered. Is there any way how I can access the number of forms submitted by
each individual.

I will be grateful for the feedback.

Regards
Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda
Tel: +256776301718

________________________________
From: Lars Helge Øverland <larshelge@gmail.com>
To: Muhumuza Kananura Rornald <mk.rornald@yahoo.com>
Cc: "dhis2-users@lists.launchpad.net" <dhis2-users@lists.launchpad.net>
Sent: Tuesday, September 11, 2012 2:12 PM
Subject: Re: [Dhis2-users] DHIS Annual Report

Hello Muhumuza,

at the moment we only support aggregated reports for the financial
year which starts in July. We can implement support for this in the
next version which is 2.10.

The work-around is to create a "report table" (reports module) where
you include the four quarters which comprise your financial year. You
then generate this report and export to Excel where you can summarize
those four quarters into the financial year.

regards,

Lars

On Mon, Sep 10, 2012 at 2:10 PM, Muhumuza Kananura Rornald > <mk.rornald@yahoo.com> wrote:

Dear;

Dear DHIS2 Users;
I am using DHIS2 in managing community health data in our organization
(CDC
funded). I am now supposed to produce an annual report for which the
financial year ends in September 31. How can I go about it.

Regards

Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda
tel: 0776301718

_______________________________________________
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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

The reporting summary rate summarises all the data sets entered and yet I want to know what each data entrant has entered. I have over 10 data entrants and I want to pay them depending on what an individual has entered.

Regards

···

From: Lars Helge Øverland larshelge@gmail.com
To: Muhumuza Kananura Rornald mk.rornald@yahoo.com
Cc: "dhis2-users@lists.launchpad.net" dhis2-users@lists.launchpad.net
Sent: Tuesday, September 11, 2012 4:19 PM
Subject: Re: Data entry

Yes, you can teach the data entrants to use the “complete” button at
the end of each form after they have filled it properly. You can then
later use the “Reporting rate summary” tool in reports module to
assess the number of forms completed. To double check whether the
forms are actually filled you can define a set of “compulsory data
elements” (click on the yellow icon next to the data set in the data
set list). Then later in reporting rate summary you can choose “Based
on compulsory data elements” as method for calculating form
submissions - a form is considered complete if values are entered for
all compulsory data elements.

On Tue, Sep 11, 2012 at 3:14 PM, Muhumuza Kananura Rornald > mk.rornald@yahoo.com wrote:

Dear Lars;
Thanks for the support.
I have data entrants who are paid according the number of forms (Data sets)
entered. Is there any way how I can access the number of forms submitted by
each individual.

I will be grateful for the feedback.

Regards
Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda
Tel: +256776301718


From: Muhumuza Kananura Rornald mk.rornald@yahoo.com
To: Lars Helge Øverland larshelge@gmail.com
Cc: "dhis2-users@lists.launchpad.net" dhis2-users@lists.launchpad.net
Sent: Tuesday, September 11, 2012 4:07 PM
Subject: Re: [Dhis2-users] DHIS Annual Report

Dear Lars;
Thanks for the support.
I have data entrants who are paid according the number of forms (Data sets)
entered. Is there any way how I can access the number of forms submitted by
each individual.

I will be grateful for the feedback.

Regards
Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda
Tel: +256776301718


From: Lars Helge Øverland larshelge@gmail.com
To: Muhumuza Kananura Rornald mk.rornald@yahoo.com
Cc: "dhis2-users@lists.launchpad.net" dhis2-users@lists.launchpad.net
Sent: Tuesday, September 11, 2012 2:12 PM
Subject: Re: [Dhis2-users] DHIS Annual Report

Hello Muhumuza,

at the moment we only support aggregated reports for the financial
year which starts in July. We can implement support for this in the
next version which is 2.10.

The work-around is to create a “report table” (reports module) where
you include the four quarters which comprise your financial year. You
then generate this report and export to Excel where you can summarize
those four quarters into the financial year.

regards,

Lars

On Mon, Sep 10, 2012 at 2:10 PM, Muhumuza Kananura Rornald > > mk.rornald@yahoo.com wrote:

Dear;

Dear DHIS2 Users;
I am using DHIS2 in managing community health data in our organization
(CDC
funded). I am now supposed to produce an annual report for which the
financial year ends in September 31. How can I go about it.

Regards

Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda
tel: 0776301718


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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

OK sorry thought a data entrant worked only within a specific org
unit. Jasons suggestion will work. You can create such an SQL report
under Data administration - SQL View. Create new, give it a name (like
"User reporting"), paste the SQL, save, generate it by clicking on
the green icon, then view it by clicking on the blue icon.

SELECT storedby, COUNT(*) FROM completedatasetregistration
WHERE date >= '2011-10-01' and date <='2012-09-30'
GROUP BY storedby;

···

On Tue, Sep 11, 2012 at 3:18 PM, Jason Pickering <jason.p.pickering@gmail.com> wrote:

There is no way to get this directly. You would need to look in the
completedatasetregistration table.

However, if you have multiple people who might submit the data for a
particular orgunit, you would not be able to distinguish who completed the
information the first time, versus the last time. The only thing this table
will show you will be the last person who "completed" the data.

I think

SELECT storedby, COUNT(*) FROM completedatasetregistration
WHERE date >= '2011-10-01' and date <='2012-09-30'
GROUP BY storedby;

might give you what you need however.

Regards,
Jason

On Tue, Sep 11, 2012 at 6:37 PM, Muhumuza Kananura Rornald > <mk.rornald@yahoo.com> wrote:

Dear Lars;
Thanks for the support.
I have data entrants who are paid according the number of forms (Data
sets) entered. Is there any way how I can access the number of forms
submitted by each individual.

I will be grateful for the feedback.

Regards
Muhumuza Kananura Rornald
Management Information System Officer
THETA Uganda
Tel: +256776301718

________________________________
From: Lars Helge Øverland <larshelge@gmail.com>
To: Muhumuza Kananura Rornald <mk.rornald@yahoo.com>
Cc: "dhis2-users@lists.launchpad.net" <dhis2-users@lists.launchpad.net>
Sent: Tuesday, September 11, 2012 2:12 PM
Subject: Re: [Dhis2-users] DHIS Annual Report

Hello Muhumuza,

at the moment we only support aggregated reports for the financial
year which starts in July. We can implement support for this in the
next version which is 2.10.

The work-around is to create a "report table" (reports module) where
you include the four quarters which comprise your financial year. You
then generate this report and export to Excel where you can summarize
those four quarters into the financial year.

regards,

Lars

On Mon, Sep 10, 2012 at 2:10 PM, Muhumuza Kananura Rornald >> <mk.rornald@yahoo.com> wrote:
> Dear;
>
> Dear DHIS2 Users;
> I am using DHIS2 in managing community health data in our organization
> (CDC
> funded). I am now supposed to produce an annual report for which the
> financial year ends in September 31. How can I go about it.
>
> Regards
>
> Muhumuza Kananura Rornald
> Management Information System Officer
> THETA Uganda
> tel: 0776301718
>
> _______________________________________________
> 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp