Creating Age range dashboard in CJA with birth date field | Community
Skip to main content
Level 2
February 11, 2024
Solved

Creating Age range dashboard in CJA with birth date field

  • February 11, 2024
  • 1 reply
  • 742 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jason_Egan

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:

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.

1 reply

Jason_Egan
Adobe Champion
Jason_EganAdobe ChampionAccepted solution
Adobe Champion
February 13, 2024

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:

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.