Re: [Dhis2-users] Conditional Indicators for Aggregated type Data Elements
Yes, it sounds like the same thing. This has come up many times as a feature request I think and sounds similar to this https://jira.dhis2.org/browse/DHIS2-1677 Its currently not possible, but you can have a look at the work from HISP Tanzania which may make this possible at least in the front-end https://play.dhis2.org/appstore/app/dXX2Fk6jwCX Regards, Jason On Wed, Nov 1, 2017 at 1:16 PM, GROUT, Lise <gro...@who.int> wrote: > Hi Rabbia, > > Would it be similar to what I asked last week: to be able to have logical > indicator, like Indicator = sum of DE1 if DE2=yes ? > > Best > Lise > > -Original Message- > From: Dhis2-users [mailto:dhis2-users-bounces+groutl=who.int@lists. > launchpad.net] On Behalf Of rab...@pace-tech.com > Sent: 01 November 2017 12:50 > To: Jason Pickering > Cc: Dhis2 Users > Subject: Re: [Dhis2-users] Conditional Indicators for Aggregated type Data > Elements > > Hi jason, > I'm asking about data element of type "Number" or "integer" .how can we > get the conditional sum for these type ? when the type is aggregated not > trackers. Like I've created Data Elements of the type aggregated, created a > 'data entry form' of these data elements. also the indicators I've created > for this till now are simple indicators but now i want to create some > indicator with condition. > Regards: Rabbia Naz > > > On 2017-11-01 15:45, Jason Pickering wrote: > > Hi Rabbia, > > What is not working? Could you be more specific? > > > > Data elements of type "True only" should aggregate to 1 when marked as > > true. > > > > Regards, > > Jason > > > > On Tue, Oct 31, 2017 at 2:05 PM, <rab...@pace-tech.com> wrote: > > > >> On 2017-10-30 19:28, Jason Pickering wrote: > >> > >>> Hi Rabbia, > >>> Just use the True Only type of data element. It should work. > >>> > >>> Regards, > >>> Jason > >> Hi Jason, > >> its not working and if we want the same thing to be done on number > >> data type or you can say integer. what i need to do then ? > >> > >> Regards: Rabbia Naz > >> > >> On Oct 30, 2017 08:09, <rab...@pace-tech.com> wrote: > >> > >> Aoa, > >> > >> I need to ask a question about indicators like i want to sum the > >> value of numerator on the basis of data element like "sum(case when > >> devalue=true then 1 else 0 end) as totaltrue". like how can we > >> calculate the conditional sum for data element whose type is > >> aggregated not tracker. Kindly explain in detail. > >> Thank You > >> Regards: Rabbia Naz > >> > >> ___ > >> Mailing list: https://launchpad.net/~dhis2-users [1] [1] Post to : > >> dhis2-users@lists.launchpad.net Unsubscribe : > >> https://launchpad.net/~dhis2-users [1] [1] More help : > >> https://help.launchpad.net/ListHelp [2] [2] > >> > >> Links: > >> -- > >> [1] https://launchpad.net/~dhis2-users [1] [2] > >> https://help.launchpad.net/ListHelp [2] > > > > -- > > > > Jason P. Pickering > > email: jason.p.picker...@gmail.com > > tel:+46764147049 > > > > Links: > > -- > > [1] https://launchpad.net/~dhis2-users > > [2] 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] Conditional Indicators for Aggregated type Data Elements
Hi Rabbia, Would it be similar to what I asked last week: to be able to have logical indicator, like Indicator = sum of DE1 if DE2=yes ? Best Lise -Original Message- From: Dhis2-users [mailto:dhis2-users-bounces+groutl=who@lists.launchpad.net] On Behalf Of rab...@pace-tech.com Sent: 01 November 2017 12:50 To: Jason Pickering Cc: Dhis2 Users Subject: Re: [Dhis2-users] Conditional Indicators for Aggregated type Data Elements Hi jason, I'm asking about data element of type "Number" or "integer" .how can we get the conditional sum for these type ? when the type is aggregated not trackers. Like I've created Data Elements of the type aggregated, created a 'data entry form' of these data elements. also the indicators I've created for this till now are simple indicators but now i want to create some indicator with condition. Regards: Rabbia Naz On 2017-11-01 15:45, Jason Pickering wrote: > Hi Rabbia, > What is not working? Could you be more specific? > > Data elements of type "True only" should aggregate to 1 when marked as > true. > > Regards, > Jason > > On Tue, Oct 31, 2017 at 2:05 PM, <rab...@pace-tech.com> wrote: > >> On 2017-10-30 19:28, Jason Pickering wrote: >> >>> Hi Rabbia, >>> Just use the True Only type of data element. It should work. >>> >>> Regards, >>> Jason >> Hi Jason, >> its not working and if we want the same thing to be done on number >> data type or you can say integer. what i need to do then ? >> >> Regards: Rabbia Naz >> >> On Oct 30, 2017 08:09, <rab...@pace-tech.com> wrote: >> >> Aoa, >> >> I need to ask a question about indicators like i want to sum the >> value of numerator on the basis of data element like "sum(case when >> devalue=true then 1 else 0 end) as totaltrue". like how can we >> calculate the conditional sum for data element whose type is >> aggregated not tracker. Kindly explain in detail. >> Thank You >> Regards: Rabbia Naz >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-users [1] [1] Post to : >> dhis2-users@lists.launchpad.net Unsubscribe : >> https://launchpad.net/~dhis2-users [1] [1] More help : >> https://help.launchpad.net/ListHelp [2] [2] >> >> Links: >> -- >> [1] https://launchpad.net/~dhis2-users [1] [2] >> https://help.launchpad.net/ListHelp [2] > > -- > > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+46764147049 > > Links: > -- > [1] https://launchpad.net/~dhis2-users > [2] 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 ___ 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] Conditional Indicators for Aggregated type Data Elements
Hi jason, I'm asking about data element of type "Number" or "integer" .how can we get the conditional sum for these type ? when the type is aggregated not trackers. Like I've created Data Elements of the type aggregated, created a 'data entry form' of these data elements. also the indicators I've created for this till now are simple indicators but now i want to create some indicator with condition. Regards: Rabbia Naz On 2017-11-01 15:45, Jason Pickering wrote: Hi Rabbia, What is not working? Could you be more specific? Data elements of type "True only" should aggregate to 1 when marked as true. Regards, Jason On Tue, Oct 31, 2017 at 2:05 PM,wrote: On 2017-10-30 19:28, Jason Pickering wrote: Hi Rabbia, Just use the True Only type of data element. It should work. Regards, Jason Hi Jason, its not working and if we want the same thing to be done on number data type or you can say integer. what i need to do then ? Regards: Rabbia Naz On Oct 30, 2017 08:09, wrote: Aoa, I need to ask a question about indicators like i want to sum the value of numerator on the basis of data element like "sum(case when devalue=true then 1 else 0 end) as totaltrue". like how can we calculate the conditional sum for data element whose type is aggregated not tracker. Kindly explain in detail. Thank You Regards: Rabbia Naz ___ Mailing list: https://launchpad.net/~dhis2-users [1] [1] Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users [1] [1] More help : https://help.launchpad.net/ListHelp [2] [2] Links: -- [1] https://launchpad.net/~dhis2-users [1] [2] https://help.launchpad.net/ListHelp [2] -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049 Links: -- [1] https://launchpad.net/~dhis2-users [2] 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] Conditional Indicators for Aggregated type Data Elements
Hi Rabbia, What is not working? Could you be more specific? Data elements of type "True only" should aggregate to 1 when marked as true. Regards, Jason On Tue, Oct 31, 2017 at 2:05 PM,wrote: > On 2017-10-30 19:28, Jason Pickering wrote: > >> Hi Rabbia, >> Just use the True Only type of data element. It should work. >> >> Regards, >> Jason >> >> Hi Jason, > its not working and if we want the same thing to be done on number data > type or you can say integer. what i need to do then ? > > Regards: Rabbia Naz > > On Oct 30, 2017 08:09, wrote: >> >> Aoa, >>> >>> I need to ask a question about indicators like i want to sum the >>> value of numerator on the basis of data element like "sum(case when >>> devalue=true then 1 else 0 end) as totaltrue". like how can we >>> calculate the conditional sum for data element whose type is >>> aggregated not tracker. Kindly explain in detail. >>> Thank You >>> Regards: Rabbia Naz >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-users [1] >>> Post to : dhis2-users@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users [1] >>> More help : https://help.launchpad.net/ListHelp [2] >>> >> >> >> Links: >> -- >> [1] https://launchpad.net/~dhis2-users >> [2] 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] Conditional Indicators for Aggregated type Data Elements
On 2017-10-30 19:28, Jason Pickering wrote: Hi Rabbia, Just use the True Only type of data element. It should work. Regards, Jason Hi Jason, its not working and if we want the same thing to be done on number data type or you can say integer. what i need to do then ? Regards: Rabbia Naz On Oct 30, 2017 08:09,wrote: Aoa, I need to ask a question about indicators like i want to sum the value of numerator on the basis of data element like "sum(case when devalue=true then 1 else 0 end) as totaltrue". like how can we calculate the conditional sum for data element whose type is aggregated not tracker. Kindly explain in detail. Thank You Regards: Rabbia Naz ___ Mailing list: https://launchpad.net/~dhis2-users [1] Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users [1] More help : https://help.launchpad.net/ListHelp [2] Links: -- [1] https://launchpad.net/~dhis2-users [2] 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] Conditional Indicators for Aggregated type Data Elements
On 2017-10-30 19:28, Jason Pickering wrote: Hi Rabbia, Just use the True Only type of data element. It should work. Regards, Jason On Oct 30, 2017 08:09,wrote: Aoa, I need to ask a question about indicators like i want to sum the value of numerator on the basis of data element like "sum(case when devalue=true then 1 else 0 end) as totaltrue". like how can we calculate the conditional sum for data element whose type is aggregated not tracker. Kindly explain in detail. Thank You Regards: Rabbia Naz ___ Mailing list: https://launchpad.net/~dhis2-users [1] Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users [1] More help : https://help.launchpad.net/ListHelp [2] Links: -- [1] https://launchpad.net/~dhis2-users [2] https://help.launchpad.net/ListHelp Hi Jason, its not working and if we want the same thing to be done on number data type or you can say integer. what i need to do then ? Regards: Rabbia Naz ___ 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] Conditional Indicators for Aggregated type Data Elements
Hi Rabbia, Just use the True Only type of data element. It should work. Regards, Jason On Oct 30, 2017 08:09,wrote: > > Aoa, > > I need to ask a question about indicators like i want to sum the value of > numerator on the basis of data element like "sum(case when devalue=true > then 1 else 0 end) as totaltrue". like how can we calculate the conditional > sum for data element whose type is aggregated not tracker. Kindly explain > in detail. > Thank You > Regards: Rabbia Naz > > ___ > 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