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
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.
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 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, <rabbia@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
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 2017-10-30 19:28, Jason Pickering wrote:
On Oct 30, 2017 08:09, <rabbia@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
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, <rabbia@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, <rabbia@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
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 rabbia@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, <rabbia@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, <rabbia@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
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