How to create Bucket

[#1]

Can anybody please tell me how to create bucket

my expression is sum(z5)/sum(z6)*100

i have to create four bucket i.e 0-90,90-95,95-100

Please help me out

[m_woolf]

Look at the class function in help.

[#3]

hi ,u can do the following in script :

if ((sum(z5)/sum(z6))*100)>0 and ((sum(z5)/sum(z6))*100)<=90, '0-90',

if((sum(z5)/sum(z6))*100)>90 and ((sum(z5)/sum(z6))*100)<=95,'90-95',

if(((sum(z5)/sum(z6))*100)>95 and ((sum(z5)/sum(z6))*100)<=100,'95-100')))

i hope it workz

[Anonymous]

You can also use what kuki_kuki_87 is suggestion as a calculated dimension in your charts.

[jagannalla]

Hope it helps you.

Use this as three different expressions, It gives each bucket wise.

0-90 ->  Sum({$<BucketFieldName={">=0<90"}>} Z5) / Sum({$<BucketFieldName={">=0<90"}>} Z6) *100

90-95 ->  Sum({$<BucketFieldName={">=90<95"}>} Z5) / Sum({$<BucketFieldName={">=90<95"}>} Z6) *100

95-100 ->  Sum({$<BucketFieldName={">=95<100"}>} Z5) / Sum({$<BucketFieldName={">=95<100"}>} Z6) *100

[#6]

Can u explain what u mean by BucketFieldName?

[jagannalla]

It is the fieldname which you want to apply buckets i.e, ranges 0-90,90-95.95-100.

[#8]

kkk

[nilesh_gangurde]

Hi sumitthakur.mpvm,

You can craete bucket at load time which and use it as Dimension with the above mension expression(sum(z5)/sum(z6)*100).

write the following script in the load :

if (FieldName <= 90,'0 - 90',if(FieldName >90 and FieldName <= 95,'90 - 95',if(FieldName > 95 and FieldName <=100,'95 - 100'))) as Bucket,

Then Dimension = Bucket And Expression = sum(z5)/sum(z6)*100)

Regards,

Nilesh Gangurde

[#10]

hi can u explain bucket analysis for interview purpose