Location wise Avg

[#1]

Hi All,

Avg Per day per Person should be bucketed

Data :-

Date	Location	Name	Handled
7/1/2015	Blr	Raj 1	1500
7/1/2015	Chn	Raj 2	1000
7/1/2015	TJ	Raj 3	600
7/1/2015	Chn	Raj 4	1000
7/3/2015	TJ	Raj 3	1000
7/3/2015	Blr	Raj 1	900
7/6/2015	Chn	Raj 2	500
7/6/2015	Blr	Raj 5	1000

Avg Per person Per day to be bucketed as given below.

Location	Row Labels	Average of Handled	Bucket
Blr	Raj 1	1200	1000 - 1500
Chn	Raj 2	750	500 - 1000
TJ	Raj 3	800	500 - 1000
Chn	Raj 4	1000	1000 - 1500
Blr	Raj 5	1000	1000 - 1500

Final Output:

Location	0 - 500	500 - 1000	1000 - 1500	> 1500
Blr			2
Chn		1	1
TJ		1

[puttemans · Accepted solution]

Latest version, with approximation of your needs I guess.

Kind regards,

Johan

[puttemans]

In the previous version, I used day as well, now I only used location.

For TJ, data differ since QV makes a difference between Raj3 and Raj 3. If you change this small error in the source data, it'll give you the desired output.

Regards,

Johan

[Kushal_Chawda]

Please see the attached

[#5]

HI,

One small query in your query you have used class function hence it is getting bucketed at an equal interval of 500 , but if i had to vary how to i do it.

[Kushal_Chawda]

Your bucket should follow the Particular interval. In your case it was 500. Now if you want 0-400, 400-800 then change 500 to 400