Expand my Community achievements bar.

Join us on September 25th for a must-attend webinar featuring Adobe Experience Maker winner Anish Raul. Discover how leading enterprises are adopting AI into their workflows securely, responsibly, and at scale.
SOLVED

Creating Age range dashboard in CJA with birth date field

Avatar

Level 2

Hi All,

 

I need to create a dashboard in CJA something like below.

 

AGE range.            number of people

20 - 25.                          10

25 - 30                           35

30-25                             26

 

but I only have birth date field in AEP. is there any way build something like this in CJA ?

 

Thanks in advance.

1 Accepted Solution

Avatar

Correct answer by
Adobe Champion

It's tough to get a rolling value like that as far as I can tell. The closest I could really get to this, directly in CJA, was to create a derived field where you return some value if the dates are between some values:

Screenshot 2024-02-13 at 12.14.50 PM.png

The only thing here is that there's not really a way to make things relative to the current day or time so that you could get a rolling age as time goes on. I'd be interested if someone was aware of another method of getting to a rolling date against a date field in AEP, directly within CJA. It might not be a bad idea to even request this as an update to derived fields in CJA.

View solution in original post

1 Reply

Avatar

Correct answer by
Adobe Champion

It's tough to get a rolling value like that as far as I can tell. The closest I could really get to this, directly in CJA, was to create a derived field where you return some value if the dates are between some values:

Screenshot 2024-02-13 at 12.14.50 PM.png

The only thing here is that there's not really a way to make things relative to the current day or time so that you could get a rolling age as time goes on. I'd be interested if someone was aware of another method of getting to a rolling date against a date field in AEP, directly within CJA. It might not be a bad idea to even request this as an update to derived fields in CJA.