Re: [Dhis2-users] Constructing indicators from boolean data elements

[Spratt, Jennifer]

Thanks very much. That is what I was doing but it took several tries for it to 
finally appear correctly in pivot tables, which it now does. Evidently even 
after running analytics and clearing all the caches and browsers, my system 
takes a while to update…

Best and thanks again,

Jennifer E. Spratt, Ph.D.
Senior Education Research Analyst
International Development Group at RTI International
Email: spr...@rti.org<mailto:spr...@rti.org>   Skype: j_spratt
Mobile: 443-562-2129  Messages: 410-235-0019

From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: Tuesday, January 02, 2018 1:59 AM
To: Spratt, Jennifer <spr...@rti.org>
Cc: Shurajit Dutta <shurajitdu...@gmail.com>; dhis1-users 
<dhis2-users@lists.launchpad.net>; Alexander, Keely <kalexan...@rti.org>; 
Kochetkova, Emily <ekochetk...@rti.org>; Preston, Adam <apres...@rti.org>; 
Pavluck, Alexandre <apavl...@rti.org>
Subject: Re: [Dhis2-users] Constructing indicators from boolean data elements

Hi Jennifer,

With aggregate data, Boolean "Yes" values will have the value of "1" in 
analytics, while "No" values will have a value of zero.

So, it should just be a matter of creating an indicator like:

Numerator: Your data element
Denominator: 1
Indicator type: Percentage

That should provide the percentage of values which responded "Yes".

Regards,
Jason Pickering




On Tue, Jan 2, 2018 at 1:01 AM, Spratt, Jennifer 
<spr...@rti.org<mailto:spr...@rti.org>> wrote:
Thanks very much, but I am working with a dataset not a program, so how do I 
access the relevant data elements in the program indicators construction app?

Jennifer E. Spratt, Ph.D.
Senior Education Research Analyst
International Development Group at RTI International
Email: spr...@rti.org<mailto:spr...@rti.org>   Skype: j_spratt
Mobile: 443-562-2129  Messages: 410-235-0019

From: Shurajit Dutta 
[mailto:shurajitdu...@gmail.com<mailto:shurajitdu...@gmail.com>]
Sent: Monday, January 01, 2018 6:22 PM
To: Spratt, Jennifer <spr...@rti.org<mailto:spr...@rti.org>>
Cc: dhis1-users 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>; 
Preston, Adam <apres...@rti.org<mailto:apres...@rti.org>>; Pavluck, Alexandre 
<apavl...@rti.org<mailto:apavl...@rti.org>>; Alexander, Keely 
<kalexan...@rti.org<mailto:kalexan...@rti.org>>; Kochetkova, Emily 
<ekochetk...@rti.org<mailto:ekochetk...@rti.org>>
Subject: Re: [Dhis2-users] Constructing indicators from boolean data elements

Hi Jennifer

In order to do this you should create two program indicators.

1. Count events with the yes responses
2. Count the total events

You can then make a combined indicator in the maintenance indicator app using 
these two program indicators.

To do this choose 'programs' followed by program indicators when you select the 
numerator/denominator

Nick


On Jan 1, 2018 6:16 PM, "Spratt, Jennifer" 
<spr...@rti.org<mailto:spr...@rti.org>> wrote:
Hello all, I am trying to create an indicator that is the proportion of 
entities that replied “yes” on a Boolean data element in a dataset. (Number 
replying yes divided by total number responding).

I have searched high and low in the DHIS2 user’s guide, but find nothing to 
help me construct what should be a pretty basic indicator.

I have specified the Indicator type as “percentage”, the numerator as #{UID}==1 
and the denominator as #{UID}>=0,  (replacing “UID” with the actual UID of 
course)  and I KNOW there are both 1s and 0s in the data element in question, 
but the result is always “0”.

Also, I thought one could use an indicator as the basis for another indicator, 
but am unable to see “indicator” among the choice of items when creating 
numerators and denominators…

PS, I have also tried +(#{UID}==1)  and #{UID}==”TRUE”  as the numerator, but 
the result is the same… Evidently filters do not work in aggregate indicator 
construction? Or do they?

Could you enlighten me as to what I may be doing wrong, and ideally, point me 
to the elegant obvious solution?

Much obliged,

Jennifer E. Spratt, Ph.D.
Senior Education Research Analyst
International Development Group at RTI International
Email: spr...@rti.org<mailto:spr...@rti.org>   Skype: j_spratt
Mobile: 443-562-2129<tel:(443)%20562-2129>  Messages: 
410-235-0019<tel:(410)%20235-0019>


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto: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<mailto:dhis2-us

Re: [Dhis2-users] Constructing indicators from boolean data elements

[Jason Pickering]

Hi Jennifer,

With aggregate data, Boolean "Yes" values will have the value of "1" in
analytics, while "No" values will have a value of zero.

So, it should just be a matter of creating an indicator like:

Numerator: Your data element
Denominator: 1
Indicator type: Percentage

That should provide the percentage of values which responded "Yes".

Regards,
Jason Pickering




On Tue, Jan 2, 2018 at 1:01 AM, Spratt, Jennifer <spr...@rti.org> wrote:

> Thanks very much, but I am working with a dataset not a program, so how do
> I access the relevant data elements in the program indicators construction
> app?
>
>
>
> *Jennifer E. Spratt, Ph.D.*
>
> Senior Education Research Analyst
>
> International Development Group at RTI International
>
> Email: spr...@rti.org   Skype: j_spratt
>
> Mobile: 443-562-2129  Messages: 410-235-0019
>
>
>
> *From:* Shurajit Dutta [mailto:shurajitdu...@gmail.com]
> *Sent:* Monday, January 01, 2018 6:22 PM
> *To:* Spratt, Jennifer <spr...@rti.org>
> *Cc:* dhis1-users <dhis2-users@lists.launchpad.net>; Preston, Adam <
> apres...@rti.org>; Pavluck, Alexandre <apavl...@rti.org>; Alexander,
> Keely <kalexan...@rti.org>; Kochetkova, Emily <ekochetk...@rti.org>
> *Subject:* Re: [Dhis2-users] Constructing indicators from boolean data
> elements
>
>
>
> Hi Jennifer
>
>
>
> In order to do this you should create two program indicators.
>
>
>
> 1. Count events with the yes responses
>
> 2. Count the total events
>
>
>
> You can then make a combined indicator in the maintenance indicator app
> using these two program indicators.
>
>
>
> To do this choose 'programs' followed by program indicators when you
> select the numerator/denominator
>
>
>
> Nick
>
>
>
>
>
> On Jan 1, 2018 6:16 PM, "Spratt, Jennifer" <spr...@rti.org> wrote:
>
> Hello all, I am trying to create an indicator that is the proportion of
> entities that replied “yes” on a Boolean data element in a dataset. (Number
> replying yes divided by total number responding).
>
>
>
> I have searched high and low in the DHIS2 user’s guide, but find nothing
> to help me construct what should be a pretty basic indicator.
>
>
>
> I have specified the Indicator type as “percentage”, the numerator as
> #{UID}==1 and the denominator as #{UID}>=0,  (replacing “UID” with the
> actual UID of course)  and I KNOW there are both 1s and 0s in the data
> element in question, but the result is always “0”.
>
>
>
> Also, I thought one could use an indicator as the basis for another
> indicator, but am unable to see “indicator” among the choice of items when
> creating numerators and denominators…
>
>
>
> PS, I have also tried +(#{UID}==1)  and #{UID}==”TRUE”  as the numerator,
> but the result is the same… Evidently filters do not work in aggregate
> indicator construction? Or do they?
>
>
>
> Could you enlighten me as to what I may be doing wrong, and ideally, point
> me to the elegant obvious solution?
>
>
>
> Much obliged,
>
>
>
> *Jennifer E. Spratt, Ph.D.*
>
> Senior Education Research Analyst
>
> International Development Group at RTI International
>
> Email: spr...@rti.org   Skype: j_spratt
>
> Mobile: 443-562-2129 <(443)%20562-2129>  Messages: 410-235-0019
> <(410)%20235-0019>
>
>
>
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
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

Re: [Dhis2-users] Constructing indicators from boolean data elements

[Spratt, Jennifer]

Thanks very much, but I am working with a dataset not a program, so how do I 
access the relevant data elements in the program indicators construction app?

Jennifer E. Spratt, Ph.D.
Senior Education Research Analyst
International Development Group at RTI International
Email: spr...@rti.org<mailto:spr...@rti.org>   Skype: j_spratt
Mobile: 443-562-2129  Messages: 410-235-0019

From: Shurajit Dutta [mailto:shurajitdu...@gmail.com]
Sent: Monday, January 01, 2018 6:22 PM
To: Spratt, Jennifer <spr...@rti.org>
Cc: dhis1-users <dhis2-users@lists.launchpad.net>; Preston, Adam 
<apres...@rti.org>; Pavluck, Alexandre <apavl...@rti.org>; Alexander, Keely 
<kalexan...@rti.org>; Kochetkova, Emily <ekochetk...@rti.org>
Subject: Re: [Dhis2-users] Constructing indicators from boolean data elements

Hi Jennifer

In order to do this you should create two program indicators.

1. Count events with the yes responses
2. Count the total events

You can then make a combined indicator in the maintenance indicator app using 
these two program indicators.

To do this choose 'programs' followed by program indicators when you select the 
numerator/denominator

Nick


On Jan 1, 2018 6:16 PM, "Spratt, Jennifer" 
<spr...@rti.org<mailto:spr...@rti.org>> wrote:
Hello all, I am trying to create an indicator that is the proportion of 
entities that replied “yes” on a Boolean data element in a dataset. (Number 
replying yes divided by total number responding).

I have searched high and low in the DHIS2 user’s guide, but find nothing to 
help me construct what should be a pretty basic indicator.

I have specified the Indicator type as “percentage”, the numerator as #{UID}==1 
and the denominator as #{UID}>=0,  (replacing “UID” with the actual UID of 
course)  and I KNOW there are both 1s and 0s in the data element in question, 
but the result is always “0”.

Also, I thought one could use an indicator as the basis for another indicator, 
but am unable to see “indicator” among the choice of items when creating 
numerators and denominators…

PS, I have also tried +(#{UID}==1)  and #{UID}==”TRUE”  as the numerator, but 
the result is the same… Evidently filters do not work in aggregate indicator 
construction? Or do they?

Could you enlighten me as to what I may be doing wrong, and ideally, point me 
to the elegant obvious solution?

Much obliged,

Jennifer E. Spratt, Ph.D.
Senior Education Research Analyst
International Development Group at RTI International
Email: spr...@rti.org<mailto:spr...@rti.org>   Skype: j_spratt
Mobile: 443-562-2129<tel:(443)%20562-2129>  Messages: 
410-235-0019<tel:(410)%20235-0019>


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto: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

Re: [Dhis2-users] Constructing indicators from boolean data elements

[Shurajit Dutta]

Hi Jennifer

In order to do this you should create two program indicators.

1. Count events with the yes responses
2. Count the total events

You can then make a combined indicator in the maintenance indicator app
using these two program indicators.

To do this choose 'programs' followed by program indicators when you select
the numerator/denominator

Nick


On Jan 1, 2018 6:16 PM, "Spratt, Jennifer"  wrote:

Hello all, I am trying to create an indicator that is the proportion of
entities that replied “yes” on a Boolean data element in a dataset. (Number
replying yes divided by total number responding).



I have searched high and low in the DHIS2 user’s guide, but find nothing to
help me construct what should be a pretty basic indicator.



I have specified the Indicator type as “percentage”, the numerator as
#{UID}==1 and the denominator as #{UID}>=0,  (replacing “UID” with the
actual UID of course)  and I KNOW there are both 1s and 0s in the data
element in question, but the result is always “0”.



Also, I thought one could use an indicator as the basis for another
indicator, but am unable to see “indicator” among the choice of items when
creating numerators and denominators…



PS, I have also tried +(#{UID}==1)  and #{UID}==”TRUE”  as the numerator,
but the result is the same… Evidently filters do not work in aggregate
indicator construction? Or do they?



Could you enlighten me as to what I may be doing wrong, and ideally, point
me to the elegant obvious solution?



Much obliged,



*Jennifer E. Spratt, Ph.D.*

Senior Education Research Analyst

International Development Group at RTI International

Email: spr...@rti.org   Skype: j_spratt

Mobile: 443-562-2129 <(443)%20562-2129>  Messages: 410-235-0019
<(410)%20235-0019>



___
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

[Dhis2-users] Constructing indicators from boolean data elements

[Spratt, Jennifer]

Hello all, I am trying to create an indicator that is the proportion of 
entities that replied "yes" on a Boolean data element in a dataset. (Number 
replying yes divided by total number responding).

I have searched high and low in the DHIS2 user's guide, but find nothing to 
help me construct what should be a pretty basic indicator.

I have specified the Indicator type as "percentage", the numerator as #{UID}==1 
and the denominator as #{UID}>=0,  (replacing "UID" with the actual UID of 
course)  and I KNOW there are both 1s and 0s in the data element in question, 
but the result is always "0".

Also, I thought one could use an indicator as the basis for another indicator, 
but am unable to see "indicator" among the choice of items when creating 
numerators and denominators...

PS, I have also tried +(#{UID}==1)  and #{UID}=="TRUE"  as the numerator, but 
the result is the same... Evidently filters do not work in aggregate indicator 
construction? Or do they?

Could you enlighten me as to what I may be doing wrong, and ideally, point me 
to the elegant obvious solution?

Much obliged,

Jennifer E. Spratt, Ph.D.
Senior Education Research Analyst
International Development Group at RTI International
Email: spr...@rti.org   Skype: j_spratt
Mobile: 443-562-2129  Messages: 410-235-0019

___
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