How To Create Custom Bucketing

[#1]

Hello,

I have this report that has too many buckets 1 to 30 buckets (see attached image). 

Is there a way to customize it in my chart? 

For example, bucket 1-5 as FirstVisit, bucket 5-10 as SecondVisit, bucket 10+ as RepeatVisit.

Each custom bucket can show either Total or % of Total.

BTW, the dimension is called RepeatBucket. 

Any help is appreciated!

[#2]

Hi,

maybe u can try "class" function to aggregate....

or u can use "aggr" function to create calculated dimension

C u,

Stefano

[#3]

Did you find the solution for your question.

[nagaiank]

You may try the following:

If(bucket <= 5,'FirstVisit', If(bucket <= 10,'SecondVisit','RepeatVisit')) as RepeatBucket