Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?
The problem is solved thank you very much