← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Using age-type attributes in program indicator calculations

 

Hey Seleman,
The issue you are referring to here asks for a change in how the Age data type functions. I think the behavior you want should already be supported, but with the syntax that Nick provided below.

One strength of calculating the age using the d2:yearsBetween() is that you would explicitly state the point in time where you want the calculation to be based on. If you look at an Age data element in the user interface, the calculation is done based on the current date - but this is not always what you want when writing program indicators. Nicks example below was calculating based on event date for example.

Markus

> 3. apr. 2018 kl. 08:52 skrev Seleman Ally <seleman_ally@xxxxxxxxx>:
> 
> Hi Markus and the team, 
> 
> I think the issue is already created on JIRA since last year. May be we should push for it because this is stopping community from benefiting with this useful feature. The Jira link to the link is
> 
> https://jira.dhis2.org/browse/DHIS2-1309?jql=text%20~%20%22Age%22 <https://jira.dhis2.org/browse/DHIS2-1309?jql=text%20~%20%22Age%22>
> 
> Issue Navigator - DHIS 2 JIRA <https://jira.dhis2.org/browse/DHIS2-1309?jql=text%20~%20%22Age%22>
> 
> 
> Issue Navigator - DHIS 2 JIRA
>  <https://jira.dhis2.org/browse/DHIS2-1309?jql=text%20~%20%22Age%22>
> 
> 
> Regards
> 
> Sele
> On Tuesday, April 3, 2018, 9:30:31 AM GMT+3, Markus Bekken <markus@xxxxxxxxx> wrote:
> 
> 
> Nayeem, thanks for the workaround.
> 
> Nick, the proposed usage should have worked. Age should be treated as a normal date data type in the program indicators. Can you create a bug in jira?
> 
> Markus
> 
>> 3. apr. 2018 kl. 03:41 skrev Nayeem Al Mifthah <n.mifthah@xxxxxxxxx <mailto:n.mifthah@xxxxxxxxx>>:
>> 
>> Hi Nick
>> I have also notice the same problem. Later created a data element in program stage and assign age in year as a calculative value from program attribute 'age'.
>> 
>> It works! 
>> 
>> Regards,
>> Nayeem Al Mifthah
>> Consultant for HSS, HMIS, M&E, GIS and Surveillance
>> 
>> Kindly ignore typos.
>> 
>> On Mon, 2 Apr 2018, 23:07 Shurajit Dutta, <shurajitdutta@xxxxxxxxx <mailto:shurajitdutta@xxxxxxxxx>> wrote:
>> Hi
>> 
>> I am trying to figure out the best method to use age-type attributes in program indicator calculations. As a simple example, let us say I want a program indicator which displays the age in years of a person. From what I can see, the age-type attribute stores its value as a date, according to the date of birth either selected or estimated based on what is entered in the years, weeks and months fields respectively during registration. If I want to use this date in a program indicator however it seems to not work correctly.
>> 
>> ie d2:yearsBetween(age, event_date) when used as an expressions as an example would not give me the correct age in years. Is there another way in which to make these types of program indicators work with the age-type attribute?
>> 
>> Thanks,
>> Nick
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users <https://launchpad.net/~dhis2-users>
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
>> Unsubscribe : https://launchpad.net/~dhis2-users <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users <https://launchpad.net/~dhis2-users>
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
>> Unsubscribe : https://launchpad.net/~dhis2-users <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
> 
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users <https://launchpad.net/~dhis2-users>
> Post to    : dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
> Unsubscribe : https://launchpad.net/~dhis2-users <https://launchpad.net/~dhis2-users>
> More help  : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>


References