| Grouping on column with non-uniform intervals [message #538589] |
Tue, 08 June 2010 07:17  |
 prodigy201 
Messages: 10
Registered: March 2010 |
Junior Member |
|
|
Hi,
I'm done with grouping on column using interval. For e.g-
0-99
100-199
200-299 ......and so on.
which has interval of 100 uniformly.
But if I want to do grouping on only one and same column with non-uniform intervals like -
1-100 (interval 100)
101-300 (interval 200)
301-600 (interval 300)
How it can be achieved?
Highly appreciate your help.
Thanks,
prodigy201
[Updated on: Tue, 08 June 2010 07:17] Report message to a moderator |
|
|
| Re: Grouping on column with non-uniform intervals [message #538655 is a reply to message #538589] |
Tue, 08 June 2010 10:59  |
|
Define a computed column
if (x < 101) { 1 };
if (x > 100 && x < 301) { 2 };
if (x > 300 && x < 601) { 3 };
Then group on that column.
Note that my syntax is probably out of whack; I can never remember until I'm in the editor whether java or navascript syntax applies, but you should get the general idea.
|
|
|
Powered by
FUDForum. Page generated in 0.02663 seconds
] 
Search
Help
Register
Login
Home
