Can somebody help me to find out how Offset works in Class() Function??
How this 3 will be used in calculation while calculating expression?
Solved! Go to Solution.
In class function 0 is normally the default starting point of the classification. By setting an offset you can change the default starting point.
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