Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Latest version, with approximation of your needs I guess.
Kind regards,
Johan
Hello Rajesh,
And if you take location as a dimension, and '= count(Handled)' as expression in a chart, you don't get the result?
Create a bucket field using an interval match or using code like this:
LOAD Date,
Location,
Name,
Handled,
If(Handled < 500, Dual('0-500', 0),
If(Handled < 1000, Dual('500-1000', 500),
If(Handled < 1500, Dual('1000-1500', 1000),
Dual('>1500', 1500)))) As Bucket
FROM ....
Now use Bucket as the cross dimension and sort it numerically (the duals will keep the order correct).
find the attached file
NO this will not work as I wanted Avg Handled and not Handled.
Raj 1 Avg Handled is 1200.How do i bucket teh Names basis teh avg handled as the bucket given by you
NO this will not work as I wanted Avg Handled and not Handled.
Raj 1 Avg Handled is 1200.How do i bucket teh Names basis teh avg handled as the bucket given by you
Location | 0 - 500 | 500 - 1000 | 1000 - 1500 | > 1500 |
Blr | 2 | |||
Chn | 1 | 1 | ||
TJ | 1 |
Average per day, per person or both?
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 |
sorry,
per day or per location? You show per location.
I've managed to calculate the averages, but have difficulties putting it in the right output you want.
Hi,
Even teh averages is not correct