calculated dimension

[#1]

I have a calculated dimension of age and i want to represent as <15, 16-25, 26-35, 36-45, 46-55, 56-65, >66 on the X-axis..help me how to get it..

[ecolomer]

o bien utilizas IntervalMatch o lo haces a través de una variable o if encadenado

[sunny_talwar]

You can create this as your calculated dimension:

If(Age < 16, '<15',

If(Age < 26, '16-25',

If(Age < 36, '26-35',

If(Age < 46, '36-45',

If(Age < 56, '46-55',

If(Age < 66, '56-65', '>66'))))))

[#4]

Thanks sunindia..but is there any other ways of doing this by using Aggr function or by using set analysis?

[sunny_talwar]

There is a class function you can use, but that usually gives equal intervals. Syntax is something like this:

=Class(Age, 10, '-')

[maleksafa]

use the class function to do that, and it takes as parameter the number of brackets that you want.

however i prefer that you do it from the script during the load and not from the chart, as it is not recommended to have calculated dimensions (for performance issues)