Can somebody help me to find out how Offset works in Class() Function??
How this 3 will be used in calculation while calculating expression?
Seems to determine where you class starts from. Look at this example:
Class(Age, 5, 'X', 3) as Class1,
Class(Age, 5, 'X') as Class2;
LOAD Ceil(Rand()* 99) as Age
Thats fine. But I tried lot with Class() calculation, here are some example:
=Class(30,4,'X',9) gives 29<=X<33
=Class(30,4,'X',8) gives 28<=X<32
=Class(30,4,'X') gives 28<=X<32
How this offset values are being used here, like?
30-9+4 or 30+9-4 like this?
From Sunny's example
Class(Age, 5, 'X') as Class2
First Class starts from 0 to 5 as no offset is given... 1st class is 0<=X<5
But for below example
Class(Age, 5, 'X', 3) as Class1
Offset is 3..and Class range is 5... Here with offset the 1st Class with end with the offset value i.e. 3
So the range would be
SOMENUMBER <= X < 3
but you have Class Range is 5 so 3-5 = -2
Range is -2<=X<3