How can I create logical buckets using data from a column in load script?

[Anonymous]

My Data has a

1. Field : name of the field is [AHT_of_Call]. Using this data I first need to build AHT bucket (as shown in the table below).

then once these buckets are available i want to count the number of records by people (which i will take from field name Created By).

I am struggling to build AHT Buckets (shown in table below) in the Load Script.

Please help

Bucket	Madhukar	Naveen	Premansh	Taufeeq	Total
60-300	158	67	52	214	491
300-420	0	1	0	4	5
420-540	0	0	0	0	0
540-660	0	0	0	0	0
660-720	0	0	0	0	0
720 & Above	0	0	0	0	0
Total	158	68	52	218	496

[shiveshsingh · Accepted solution]

You can create buckets by calculated dimension

=if([Aht Of Call]>=60 and [Aht Of Call]<=300,'60-300',if([Aht Of Call]>='300' and [Aht Of Call]<='420', '300-420',if([Aht Of Call]>='420' and [Aht Of Call]<='540','420-540',

if([Aht Of Call]>='540' and [Aht Of Call]<='660', '540-660', if([Aht Of Call]>='660' and [Aht Of Call] ='720', '660-720', '720 & Above')))))

[kaushiknsolanki]

Hi,

You can write simple if statements like below.

If( [AHT_of_Call] <=60,'0-60',

If( [AHT_of_Call] <=300,'60-300',

If( [AHT_of_Call] <=420,'300-420',

.......... ) as Bucket

And use this field in your chart dimension.

Regards,

Kaushik Solanki

[Anonymous]

Thanks !!.. this helps

[Anonymous]

thanks this helps

[shiveshsingh]

Please close the thread by marking correct answer