Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have teh data as given below. Need to bucket the instances.
Location | Name | Date | Message |
Bangalore | B, Ananthakrishnan | 2015-07-02 | 21 |
Bangalore | B, Ananthakrishnan | 2015-07-07 | 9 |
Bangalore | B, Ananthakrishnan | 2015-07-10 | 5 |
Bangalore | B, Ananthakrishnan | 2015-07-12 | 241 |
Bangalore | B, Ananthakrishnan | 2015-07-13 | 214 |
Bangalore | B, Geetha | 2015-07-02 | 1473 |
Bangalore | B, Geetha | 2015-07-07 | 1162 |
Bangalore | B, Geetha | 2015-07-10 | 1158 |
Bangalore | B, Geetha | 2015-07-13 | 1212 |
Bangalore | B,Harish | 2015-07-12 | 83 |
Bangalore | B,Harish | 2015-07-13 | 67 |
Bangalore | Babu, Bojanapu Dinakar | 2015-07-02 | 653 |
Bangalore | Babu, Bojanapu Dinakar | 2015-07-07 | 285 |
Bangalore | Babu, Bojanapu Dinakar | 2015-07-10 | 268 |
Bangalore | Babu, Bojanapu Dinakar | 2015-07-13 | 397 |
Final output in table should be as given below.
Bucket | Bangalore | Chennai |
0-600 | 10 | 0 |
600-800 | 1 | 0 |
800-1000 | 0 | 0 |
1000-1500 | 0 | 4 |
>1500 | 0 | 0 |
Attaching my QVW file for reference
May be something like this?
Dimension 1:
=If(Message <= 600, '0-600',
If(Message <= 800, '600-800',
If(Message <= 1000, '800-1000',
If(Message <= 1500, '1000-1500', '>1500'))))
Dimension 2: Location
Expression: Count(Location)
Since Chennai is not there in your sample data, this is what you will get with the provided data:
Hi,
Its working for the sample data provided by me.BUt in actual i am getting the data from 3 data sources and concatenating them where i am giving alias name for the header related to Message in the 3 data sources as 'Messages'.in that case this code does not seem to work.Attaching the QVW for your reference. !