Professional > Table scripting > Table specification syntax > Special elements > Banding numeric variables
 
Banding numeric variables
Sample Script File: SpecialElements.mrs
This example script is based on the Museum sample data set. See Running the sample table scripts for information on running the example scripts.
visits{visits1_5 '1 to 5' expression('visits > 0 And visits < 6'),
   visits6_10 '6 to 10' expression('visits > 5 And visits < 11'),
   visits11_20 '11 to 20' expression('visits > 10 And visits < 21'),
   visits21ormore 'More than 20' expression('visits > 20'),
   mean 'Mean' mean(visits), Stddev 'Standard deviation' stddev(visits)}
This example creates an axis based on the visits numeric variable and uses custom expressions to band the responses into categories. It also includes mean and standard deviation special elements based on the numeric variable.
Here is a table that has this axis on the side:
See also
Special elements