Age and Age Range

[Anonymous]

Hello guys,

I have this problem that i should create Age and Age Range in script so i add it like:

Age(Today(), date_of_birth) as Age,

    If(Age(Today(), date_of_birth) <= 20, Dual('<=20', 1),

    If(Age(Today(), date_of_birth)<= 30, Dual('20-30', 2),

    If(Age(Today(),date_of_birth)<= 40, Dual('30-40', 3),

    If(Age(Today(), date_of_birth) > 60, Dual('60-above',4))))) as AgeRange,

and it works but when i want to add it as dimension it doesn't show up with the others columns , any suggestion please!

[sunny_talwar]

but when i want to add it as dimension it doesn't show up with the others columns , any suggestion please!

What other dimensions? And both Age and Age_Range don't show up? Can you share your complete script?

[Anonymous]

The problem is solved thank you very much