How to bucket the calculated value in pie chart dimension?

[mohan_1105]

Hi,

I am trying to visualize the number of customers who falls in the specified bucket category. Bucket category is based on probability I calculated (Please take a look at sample App). I wanted to see the bucket proportion in a pie chart. I cannot able to specify the bucket name in chart dimension.

Please help me to build the chart and also please make me understand why pie chart cannot have calculated dimension like straight does.

A sample file is attached with this discussion.

Thanks,

Mohan.

[rupamjyotidas]

Probably create the bucket in script.

If(Sum(Customer)>1 and SUm(Customer)<10, 1-10, .....)

[mohan_1105]

Hi Rupam,

Yeah, definitely that will work and also make the work easier. But unfortunately, I have set inside my expression. Please have a look at my app. You will get to know the problem I face actually.

Thanks

[sunny_talwar · Accepted solution]

Is this what you envisioned?

Dimension

=Aggr(if((count(distinct BILLDATE) / Count({<CATEGORY=>} distinct BILLDATE)) >= '0.8','A',

if((count(distinct BILLDATE) / Count({<CATEGORY=>} distinct BILLDATE)) >= '0.5','B',

'C')), CUSTOMER)

Expression

Count(DISTINCT CUSTOMER)

[mohan_1105]

Thanks for helping me once again, Sunny.