Have been trying to create a program indicator for calculation of Age (in years) using the ‘d2yearsBetween’ expression (have tried with ‘d2daysBetween’ as well), and then putting the attribute for date of birth, and event/current date. The date of birth is not part of the attribute list in the ‘Expression’ part of the program indicator, hence the attribute UID (for DOB) is used instead in the expression.
Although the expression is shown as valid, but the output is still ‘NaN’.
Similar indicators are available on the dev instance (DHIS 2 Demo - Sierra Leone) for the MNCH program for Mother’s Age at visit in years/days, but there also the value shows as ‘NaN’.
Would appreciate some help around this, if this can be fixed, or we are doing something wrong here!
The d2:yearsBetween() is not yet supported in the server side aggregation of program indicators. For now you would have to use d2:daysBetween() / 365 - which is not 100% correct as the leap years is not considered. You wrote d2daysBetween in your mail below(without the colon between d2 and daysBetween), but i assume that was a typo in the mail.
If you used the expression d2:daysBetween(A{yourDateOfBirthAttributeUID},V{event_date}) / 365 that should work fine on both the server and client side. Let me know if this was the expression you tried. Note that the attribute UID should be prefixed with A.
In the dev instance the example indicators on the MNCH / PHC program use the V{event_date} as basis for the age calculation. This causes the indicators to be calculated to NaN until you enter an event date. If you do not explicitly want the age at the event, you can use V{enrollment_date} instead.
Markus
P.S. The attributes of type date is not shown in the expression part of the Program Indicator UI, only in the filter further down. This is all getting reworked and sorted out soon, but as a workaround for avoiding typos you can add the attribute in the filter part of the UI then cut'n'paste.
···
18. okt. 2016 kl. 18.11 skrev Saurabh <saurabh.leekha87@gmail.com>:
Hi Devs
Have been trying to create a program indicator for calculation of Age (in years) using the ‘d2yearsBetween’ expression (have tried with ‘d2daysBetween’ as well), and then putting the attribute for date of birth, and event/current date. The date of birth is not part of the attribute list in the ‘Expression’ part of the program indicator, hence the attribute UID (for DOB) is used instead in the expression.
Although the expression is shown as valid, but the output is still ‘NaN’.
Similar indicators are available on the dev instance (https://play.dhis2.org/dev/\) for the MNCH program for Mother’s Age at visit in years/days, but there also the value shows as ‘NaN’.
Would appreciate some help around this, if this can be fixed, or we are doing something wrong here!
The d2:yearsBetween() is not yet supported in the server side aggregation of program indicators. For now you would have to use d2:daysBetween() / 365 - which is not 100% correct as the leap years is not considered. You wrote d2daysBetween in your mail below(without the colon between d2 and daysBetween), but i assume that was a typo in the mail.
If you used the expression d2:daysBetween(A{yourDateOfBirthAttributeUID},V{event_date}) / 365 that should work fine on both the server and client side. Let me know if this was the expression you tried. Note that the attribute UID should be prefixed with A.
In the dev instance the example indicators on the MNCH / PHC program use the V{event_date} as basis for the age calculation. This causes the indicators to be calculated to NaN until you enter an event date. If you do not explicitly want the age at the event, you can use V{enrollment_date} instead.
Markus
P.S. The attributes of type date is not shown in the expression part of the Program Indicator UI, only in the filter further down. This is all getting reworked and sorted out soon, but as a workaround for avoiding typos you can add the attribute in the filter part of the UI then cut’n’paste.
Have been trying to create a program indicator for calculation of Age (in years) using the ‘d2yearsBetween’ expression (have tried with ‘d2daysBetween’ as well), and then putting the attribute for date of birth, and event/current date. The date of birth is not part of the attribute list in the ‘Expression’ part of the program indicator, hence the attribute UID (for DOB) is used instead in the expression.
Although the expression is shown as valid, but the output is still ‘NaN’.
Similar indicators are available on the dev instance (https://play.dhis2.org/dev/) for the MNCH program for Mother’s Age at visit in years/days, but there also the value shows as ‘NaN’.
Would appreciate some help around this, if this can be fixed, or we are doing something wrong here!