my requirement is in dimension field i want the required output

[sumitjadhav]

my requirement is in dimension field i want the required output

[vikasmahajan]

Use Calculated dimensions.

Vikas

[gautik92]

calculated dimesions

[sumitjadhav]

how to use it pls explain?

[sumitjadhav]

some example???

[gautik92]

if you could explain your scenario or post some sample data we can explain you better

[arulsettu]

for example you have age field like this

1,2,3,4,5,6,7,8,9,10

if you want to show in a chart like this

0-2, 2-4,4-6,6-8,8-10

then you can add calculated dimension in dimension tab

and write like this

class(age,2)

[sumitjadhav]

thanks bro, but i want to develop this scenario at backend by using script.

[gautik92]

With the Arul Settu  Example

you can add that in the script

lik

Load

...

class(age,2)   as ageRange,

from table

[arulsettu]

you can do at backend also

load

CLASS(AGE,2) AS age

from

.....