Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Look at the class function in help.
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
You can also use what kuki_kuki_87 is suggestion as a calculated dimension in your charts.
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
Can u explain what u mean by BucketFieldName?
It is the fieldname which you want to apply buckets i.e, ranges 0-90,90-95.95-100.
kkk
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
hi can u explain bucket analysis for interview purpose