Age

[subbareddykm]

Hi all,

I need to build one logic on Age buckets.But i m not able to do it.

Can any one hep me out in this.

I have Date fieldd Join Date and END date in my app.i m filtering Joining date .For Example i want to count Id's Passing Joining date  <=31-07-2016 and I m getting ID of it. and Also i have DOB of ID.So for Every ID i have DOB , on this i want to create Age as On My Input DAte.

Exam One of My ID has 01-01-1960 To this ID I need to Create Age.

[ankali1990]

Hello,

I read your post couple of times. You want to create second input box with DOB or the first one is not working?

Regards.

[subbareddykm]

i m not able to create age against every ID wise.

I want to create Age Bucket?

Did u see one calculated list box there ?

Its not working.

[subbareddykm]

I want out put like this       :

ID	0-25	26-35	36-50	50&Above

and I want see ID belongs to which age group

[agomes1971]

Hi,

please see attached.

Regards

André Gomes

[subbareddykm]

I dont want on Today(), user wants to consider his input date.

if i consider Today, age mismatch is coming.

Based on his input date ,we need to caluculate Age like that

[svinnakota]

Hi, I guess the input date which you are referring is VDate variable containing '31-07-2016'.

Adding to agomes1971‌ point. If you replace the Dimension Value Today() with $(VDate) i guess you can get the required output. If not please mention clearly what is the input date/column which you are referring to..

Let me know your comments..

[MarcoWedel · Accepted solution]

Hi,

one solution might be:

hope this helps

regards

Marco