class - script and chart function

The class function assigns the first parameter to a class interval. The result is a dual value with a<=x<b as the textual value, where a and b are the upper and lower limits of the bin, and the lower bound as numeric value.

Syntax:

class(expression, interval [ , label [ , offset ]])

Arguments:

Argument	Description
interval	A number that specifies the bin width.
label	An arbitrary string that can replace the 'x' in the result text.
offset	A number that can be used as offset from the default starting point of the classification. The default starting point is normally 0.

Example	Result
class( var,10 ) with var = 23	returns '20<=x<30'
class( var,5,'value' ) with var = 23	returns '20<= value <25'
class( var,10,'x',5 ) with var = 23	returns '15<=x<25'

In this example, we load a table containing name and age of people. We want to add a field that classifies each person according to an age group with a ten year interval. The source table looks like this:

Name	Age
John	25
Karen	42
Yoshi	53

To add the age group classification field, you can add a preceding load statement using the class function. In this example, we load the source table using inline data.

LOAD *, class(Age, 10, 'age') As Agegroup; LOAD * INLINE [ Age, Name 25, John 42, Karen 53, Yoshi];

The resulting data that is loaded looks like this:

Name	Age	Agegroup
John	25	20 <= age < 30
Karen	42	40 <= age < 50
Yoshi	53	50 <= age < 60

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here