dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>> 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.pickering@xxxxxxxxx
tel:+46764147049