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.
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
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
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
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
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
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
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
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
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
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.
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
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
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
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: DHIS 2 Users in Launchpad
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : DHIS 2 Users in Launchpad
> More help : ListHelp - Launchpad Help
>