dhis2-users team mailing list archive

["Tran Chau (HISP Vietnam)" <tran.hispvietnam@xxxxxxxxx>]

Hi Yoann,

I think you can define an aggregate formula for 0-5 years as follows:

 DATEDIFF(executionDate , [DE:*x.y.z*] )  >= 0 and  DATEDIFF(executionDate
*, *[DE:x.y.z] )  <= *1825*

In which:
*x *: The id of program
*y *: The id of Program stage
*z* : The id of "Date of birth" data element
*1825 *: 5 years ( 5 * 365 )

I hope it is useful.

.........

Best regards,
Tran Chau


On Mon, Jan 12, 2015 at 11:11 PM, Yoann Mira <ym@xxxxxxxxxx> wrote:

> Hi all,
>
> I'm quite new to dhis2, and still learning it. I'm using dhis v2.17.
>
> I'm working with the tracker model, I have created a program (single event
> without registration) and I'm creating a report from my events that shows
> aggregated values. This works.
>
> BUT, in my event capture, I fill a data element called 'Date of birth'
> (with
> type Date), and in my report I would like these values aggregated by range
> (0 to 5 years; 5 to 10 years; ...).
> Is that possible?
>
> Best regards,
>
> Yoann MIRA - SOLUTIONS ENGINEER
> NOVEL-T Sàrl
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>