Tabulate

Associated Constructors

Tabulate

Syntax: Tabulate( Add Table( Column Table( Analysis Columns( column(s) )|Grouping Columns( column(s))|Statistics( )), Row Table( Analysis Columns( column(s) )|Grouping Columns( column(s))|Statistics( )) )

Description: Creates a custom table of summary statistics of one or more variables. The variables can be grouped by one or more classification columns. Enables you to build the summary table using drag and drop operations.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);

Item Messages

Add

Syntax: add (<Column Table | Row Table>(table index), <before first | <before | after>(<analysis column | grouping column | statistic>(<operand name | index>))>, <analysis column | grouping column | statistic>(operand name)),

Description: Used with Modify Table to add columns and statistics to an existing table. Also serves as an alias for Add Table

Example 1


dt = Open( "$SAMPLE_DATA/Companies.jmp" );
obj = dt << Tabulate(
    Show Control Panel( 0 ),
    Add Table(
        Column Table(
            Grouping Columns( :Type ),
            Analysis Columns( :"Sales ($M)"n, :Assets ),
            statistics( min, mean, max )
        )
    )
);
Wait( 0 );
obj << modify table(
    column table( 1 ),
    Add( After( Statistics( max ) ), Statistics( Range ) )
);

Example 2


dt = Open( "$SAMPLE_DATA/Companies.jmp" );
obj = dt << Tabulate(
    Show Control Panel( 0 ),
    Add Table(
        Column Table(
            Grouping Columns( :Type ),
            Analysis Columns( :"Sales ($M)"n, :Assets ),
            statistics( min, mean, max )
        )
    )
);
Wait( 0 );
obj << modify table( column table( 1 ), Add( Before First, Statistics( Range ) ) );

Add Table

Syntax: Add Table( <Column Table( )>, <Row Table( )> )

Description: Adds a table to the window if there is no current table or appends a table to the existing table object.

Example 1


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Add Table( Column Table( Grouping Columns( :type ) ) );

Example 2


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Tabulate();
obj << Add Table( Column Table( Grouping Columns( :sex ) ) );
obj << Add table( row table( grouping column( :age ) ) );

Aggregate Statistics

Syntax: Aggregate Statistics( column )

Description: Adds a separate column for each level of the specified column together with a summation column to the current table. When scripting, the Aggregate Statistics message must be within either a Column Table message or a Row Table message.


dt = Open( "$SAMPLE_DATA/Cities.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Analysis columns( :OZONE ), statistics( mean ) ),
        Row Table( Grouping Columns( :Region ), aggregate statistics( :Region ) )
    )
);

Analysis Columns

Syntax: Analysis Columns( Column(s) )

Description: Adds analysis columns to the current table. It can be used with the Add Table command or Modify Table command.

Example 1


dt = Open( "$SAMPLE_DATA/Cities.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Analysis Columns( :OZONE ), Statistics( Mean ) ),
        Row Table( Grouping Columns( :Region ) )
    )
);

Example 2


dt = Open( "$SAMPLE_DATA/Cities.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Analysis Columns( :OZONE ), Statistics( Mean ) ),
        Row Table( Grouping Columns( :Region ) )
    )
);
obj << modifytable( column table( 1 ), analysis columns( :CO ) );

Change Item Label

Syntax: obj << Change Item Label( Statistics( stat name, new string ) )

Description: Changes the label on a text entry field in the table.


dt = Open( "$SAMPLE_DATA/Cities.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Analysis Columns( :OZONE ), Statistics( Mean ) ),
        Row Table( Grouping Columns( :Region ) )
    )
);
obj << Change Item Label( Statistics( Mean, "Average" ) );

Columns by Categories

Syntax: Columns by Categories( column1, column2, ...) )

Description: Adds a cross-tabulation of the column names and the categories gathered for columns with similar values to the table. When scripting, the Columns by Categories message must be within either a Column Table message or a Row Table message.

Example 1


dt = Open( "$SAMPLE_DATA/Children's Popularity.jmp" );
obj = dt << Tabulate(
    Add Table( Row Table( Columns by Categories( :Grades, :Sports, :Looks, :Money ) ) )
);

Example 2


dt = Open( "$SAMPLE_DATA/Children's Popularity.jmp" );
obj = dt << Tabulate(
    Add Table( Row Table( Columns by Categories( :Grades, :Sports, :Looks ) ) )
);
obj << modify table( row table( 1 ), columns by categories( :Money ) );

Delete

Syntax: delete( <analysis columns | grouping columns | statistics>(operand name, operand name, ...))

Description: Used with Modify Table to remove columns and statistics from an existing table.


dt = Open( "$SAMPLE_DATA/Companies.jmp" );
obj = dt << Tabulate(
    Show Control Panel( 0 ),
    Add Table(
        Column Table(
            Grouping Columns( :Type ),
            Analysis Columns( :"Sales ($M)"n, :Assets ),
            statistics( min, mean, max )
        )
    )
);
Wait( 0 );
obj << modify table( column table( 1 ), delete( analysis columns( :Assets ) ) );

Display Column Width

Syntax: obj << Display Column Width( Data Column( <Column Table(n)>, path ), <width> );obj << Display Column Width( Row Label( <Row Table(n)>, path ), <width> )

Description: Sets or returns the display width of a column in a Tabulate report table. Path is a sequence of quoted column headings that traces the path of the column. Width is the width of a column in pixels. Use Data Column to define columns in the main body of the table or Row Label for columns in the row labels area. If there are multiple tables in the report, use Column Table(n) or Row Table(n) to specify which table the path applies to. If width is not specified, this option returns the current width of the specified column.

Example 1


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table(
            Grouping Columns( :sex, :marital status ),
            Analysis Columns( :age ),
            Statistics( Sum, "% of Total" )
        ),
        Row Table( Grouping Columns( :type ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Display Column Width( Row Label( Row Table( 2 ), "country" ), 150 );

Example 2


dt = Open( "$SAMPLE_DATA/Cities.jmp" );
obj = dt << Tabulate(
    Set Format( Mean( :OZONE( 6, 4 ) ) ),
    Add Table(
        Column Table( Analysis Columns( :OZONE ), Statistics( Min, Max, Mean, std dev ) ),
        Row Table( Grouping Columns( :Region ) )
    )
);
stats = {"Min", "Max", "Mean", "Std Dev"};
ns = N Items( stats );
a = {};
For( i = 1, i <= ns, i++,
    a[i] = obj << Display Column Width( Data Column( "OZONE", stats[i] ) )
);
amax = Max( a );
For( i = 1, i <= ns, i++,
    obj << Display Column Width( Data Column( "OZONE", stats[i] ), amax )
);

Example 3


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table(
            Grouping Columns( :sex, :marital status ),
            Analysis Columns( :age ),
            Statistics( Sum, "% of Total" )
        ),
        Row Table( Grouping Columns( :type ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Display Column Width( Row Label( Row Table( 2 ), "country" ) );

Freq

Syntax: Freq( Column )

Description: Specify the frequency column to be used in computing for statistics


dt = Open( "$SAMPLE_DATA/Quality Control/Failures.jmp" );
obj = dt << Tabulate( Add Table( Row Table( Grouping Columns( :Causes ) ) ) );
Wait( 1 );
obj << Freq( :Count );

Full Path Column Name

Syntax: obj << Full Path Column Name( true | false )

Description: If set, column name for output table should include the grouping columns name


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Full Path Column Name( 1 );
obj << Make Into Data Table;

Grouping Columns

Syntax: Grouping Columns( Column(s) )

Description: Adds grouping columns to the current table. It can be used with the Add Table command or Modify Table command.

Example 1


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);

Example 2


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Tabulate();
obj << Add Table( Column Table( Grouping Columns( :sex ) ) );
obj << modify table( column table( 1 ), grouping column( :age ) );

ID

Syntax: ID( Column )

Description: Specifies the identifier column that is used to count unique occurrences.


dt = Open( "$SAMPLE_DATA/Hybrid Fuel Economy.jmp" );
obj = dt << Tabulate(
    Set Format( Uniform Format( 10, 2 ) ),
    Add Table(
        Column Table(
            Statistics( Sum ),
            Analysis Columns( :City MPG, :Hwy MPG, :Comb MPG ),
            Pack(
                Analysis Columns( City MPG, Hwy MPG, Comb MPG ),
                Template( "^FIRST  (^OTHERS)", "/" )
            )
        ),
        Row Table( Grouping Columns( :Mfr Name ) )
    )
);
Wait( 1 );
obj << ID( :Division );

Ignore duplicate responses

Syntax: obj << Ignore duplicate responses( Grouping Columns( column ), true | false )

JMP Version Added: 19

Ignore duplicates in multiple response columns

Syntax: obj << Ignore duplicates in multiple response columns( state=0|1 )

Description: Ignores duplicate responses in multiple response columns. Each repeated response is treated as a single occurrence.

JMP Version Added: 19

Include missing for grouping columns

Syntax: obj << Include missing for grouping columns( state=0|1 )

Description: Adds a separate column containing counts for missing values for all grouping columns in the current table.


dt = Open( "$SAMPLE_DATA/Cars.jmp" );
obj = dt << Tabulate(
    Add Table( Row Table( Grouping Columns( :Doors ) ) ),
    Include missing for grouping columns( 1 )
);

Make Into Data Table

Syntax: obj << Make Into Data Table( <Invisible(bool) | Private(bool)>, <Output Table ( table name)>, <Full Path Column Name(bool)> )

Description: Creates a new data table from the table created in Tabulate.

Example 1


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Make Into Data Table;

Example 2


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Make into Data Table( invisible( 1 ) );

Example 3


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Make into Data Table( Full Path Column Name( 1 ) );

Max scroll locked columns

Syntax: obj << Max scroll locked columns( number=3 )

Description: Set the maximum number of columns to be scroll locked. Either all or none of the row header columns will be locked. On by default.

JMP Version Added: 19


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Max Scroll Locked Columns( 1 );
obj << Make Into Data Table;

Missing sum is zero

Syntax: obj << Missing sum is zero( state=0|1 )

Modify Table

Syntax: obj << Modify Table( <Column Table | Row Table>(table index), ... )

Description: Modifies an existing table.

Example 1


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Tabulate();
obj << Add Table( Column Table( Grouping Columns( :sex ) ) );
obj << Add table( row table( grouping column( :age ) ) );
obj << Add Table( Column Table( Analysis Column( :height ) ) );
obj << Add Table( Column Table( Analysis Column( :Weight ) ) );
obj << Modify Table( Column Table( 2 ), statistics( min, max ) );
obj << Modify Table( Column Table( 2 ), grouping columns( :sex ) );
obj << Modify Table( Column Table( 2 ), Analysis Column( :Weight ) );
Wait( 1 );
obj << Modify Table( Column Table( 2 ), delete( Analysis Column( :Weight ) ) );
obj << Modify Table( Column Table( 2 ), delete( statistics( "sum" ) ) );

Example 2


dt = Open( "$SAMPLE_DATA/Companies.jmp" );
obj = dt << Tabulate(
    Show Control Panel( 0 ),
    Add Table(
        Column Table(
            Grouping Columns( :Type ),
            Analysis Columns( :"Sales ($M)"n, :Assets ),
            statistics( min, mean, max )
        )
    )
);
Wait( 0 );
obj << modify table( column table( 1 ), delete( analysis columns( :Assets ) ) );

Modify Table Option

Syntax: obj << Modify Table Option

Description: Used with Modify Table to modify table options in an existing table.

Example 1


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Tabulate(
    Show Control Panel( 0 ),
    Add Table(
        Column Table( Analysis Columns( :height ), Statistics( Mean ) ),
        Row Table( Grouping Columns( :age, :sex ) )
    )
);
obj << Modify Table( Row Table( 1 ), Modify Table Option( Stack Grouping Columns( true ) ) );

Example 2


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Tabulate(
    Show Control Panel( 0 ),
    Add Table(
        Column Table( Analysis Columns( :height ), Statistics( Mean ) ),
        Row Table( Grouping Columns( :age, :sex ), Stack Grouping Columns( 1 ) )
    )
);
obj << Modify Table(
    Row Table( 1 ),
    Modify Table Option( Change Stacked Group Label ),
    "new label"
);

Move

Syntax: move (<Column Table | Row Table>(table index), <analysis column | grouping column | statistic>(<operand name | index>)), <before first | <before | after>(<analysis column | grouping column | statistic>(<operand name | index>)>)

Description: Used with Modify Table to move columns and statistics in an existing table.

Example 1


dt = Open( "$SAMPLE_DATA/Companies.jmp" );
obj = dt << Tabulate(
    Show Control Panel( 0 ),
    Add Table(
        Column Table(
            Grouping Columns( :Type ),
            Analysis Columns( :"Sales ($M)"n, :Assets ),
            statistics( min, mean, max )
        )
    )
);
Wait( 0 );
obj << modify table(
    column table( 1 ),
    move( column table( 1 ), Statistics( mean ) ),
    After( Statistics( max ) )
);

Example 2


dt = Open( "$SAMPLE_DATA/Companies.jmp" );
obj = dt << Tabulate(
    Show Control Panel( 0 ),
    Add Table(
        Column Table(
            Grouping Columns( :Type ),
            Analysis Columns( :"Sales ($M)"n, :Assets ),
            statistics( min, mean, max )
        )
    )
);
Wait( 0 );
obj << modify table(
    row table( 1 ),
    move( column table( 1 ), Grouping Column( :Type ) ),
    before first
);

Order By Count

Syntax: obj << Order By Count( Grouping Columns( column ), true | false )

Order by count of grouping columns

Syntax: obj << Order by count of grouping columns( state=0|1 )

Description: Sorts the levels of the grouping columns by counts in the table.


dt = Open( "$SAMPLE_DATA/Cars.jmp" );
obj = dt << Tabulate( Add Table( Row Table( Grouping Columns( :Make ) ) ) );
obj << Order by Count of Grouping Columns( 1 );

Pack

Syntax: obj << Pack( <Analysis columns | Statistics>(operand name, ...), <Template> )

Description: Pack multiple statistics into one column in the table. The Template option specifies the formatting of the items.

Example 1


dt = Open( "$SAMPLE_DATA/Hybrid Fuel Economy.jmp" );
obj = dt << Tabulate(
    Show Control Panel( 0 ),
    Add Table(
        Column Table(
            Statistics( Sum ),
            Analysis Columns( :City MPG, :Hwy MPG, :Comb MPG ),
            Pack(
                Analysis Columns( City MPG, Hwy MPG, Comb MPG ),
                Template( "^FIRST  (^OTHERS)", "/" )
            )
        ),
        Row Table( Grouping Columns( :Mfr Name, :Engine ) )
    )
);

Example 2


dt = Open( "$SAMPLE_DATA/Hybrid Fuel Economy.jmp" );
obj = dt << Tabulate(
    Show Control Panel( 0 ),
    Add Table(
        Column Table( Statistics( Sum ), Analysis Columns( :City MPG, :Hwy MPG, :Comb MPG ) ),
        Row Table( Grouping Columns( :Mfr Name, :Engine ) )
    )
);
obj << Modify Table(
    Column Table( 1 ),
    Pack(
        Analysis Columns( City MPG, Hwy MPG, Comb MPG ),
        Template( "^FIRST  (^OTHERS)", "/" )
    )
);

Page Column

Syntax: Page Column( Column )

Description: Specify the page column to be used for setting up pages of report


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Analysis Columns( :height, :weight ), Statistics( Mean ) ),
        Row Table( Grouping Columns( :age ) )
    )
);
Wait( 1 );
obj << page column( :sex( "F" ) );

Plot Scale

Syntax: obj << Plot Scale( min, max )

Description: Sets the scale on the bar chart.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Show Chart( 1 );
Wait( 2 );
obj << Plot Scale( 0, 25 );

Remove Column Label

Syntax: obj << Remove Column Label( Grouping Columns( column ) )

Description: Removes the specified column label in the table.


dt = Open( "$SAMPLE_DATA/Cities.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :Region ) ),
        Row Table( Analysis Columns( :OZONE, :CO, :NO, :SO2 ), Statistics( Mean ) )
    )
);
Wait( 2 );
obj << Remove Column Label( Grouping Columns( :Region ) );

Restore Column Label

Syntax: obj << Restore Column Label( Grouping Columns( column ) )

Description: Restores the previously removed, specified column label in the table.


dt = Open( "$SAMPLE_DATA/Cities.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :Region ) ),
        Row Table( Analysis Columns( :OZONE, :CO, :NO, :SO2 ), Statistics( Mean ) )
    )
);
obj << Remove Column Label( Grouping Columns( :Region ) );
Wait( 2 );
obj << Restore Column Label( Grouping Columns( :Region ) );

Retype

Syntax: Retype( <Analysis Columns | Grouping Columns>( operand name, ... ), <Analysis Column | Gropuing Column> )

Description: Used with Modify Table to convert between analysis columns and grouping columns in an existing table.


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Tabulate(
    Show Control Panel( 0 ),
    Add Table(
        Column Table( Statistics( N ), Grouping Columns( :age ) ),
        Row Table( Grouping Columns( :sex ) )
    )
);
obj << Modify Table( Column Table( 1 ), Retype( Grouping Column( :age ) ), Analysis Column );

Save grouping as tags in data table export

Syntax: obj << Save grouping as tags in data table export( state=0|1 )

Description: Sets if the grouping levels should be included in the data table as column tags. On by default.

JMP Version Added: 19


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Save grouping as tags in data table export( 0 );
obj << Make Into Data Table;

Scroll lock row headers in data table export

Syntax: obj << Scroll lock row headers in data table export( state=0|1 )

Description: Sets if the columns containing the row headers should be scroll locked. On by default.

JMP Version Added: 19


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Scroll lock row headers in data table export( 0 );
obj << Make Into Data Table;

Set Format

Syntax: Set Format( statistic( Column( format ) )

Description: Sets the format displayed for analysis columns.

Example 1


dt = Open( "$SAMPLE_DATA/Cities.jmp" );
obj = dt << Tabulate(
    Set Format( Mean( :OZONE( 6, 4 ) ) ),
    Add Table(
        Column Table( Analysis Columns( :OZONE ), Statistics( Mean ) ),
        Row Table( Grouping Columns( :Region ) )
    )
);

Example 2


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Tabulate(
    Set Format(
        Mean(
            :height( 10, 1 ),
            Analysis Column(
                Transform Column( "Log[height]", Formula( Log( :height ) ) ),
                Format( 10, "Best" )
            )
        ),
        "% of Total"n(
            :height( 12, 2 ),
            Analysis Column(
                Transform Column( "Log[height]", Formula( Log( :height ) ) ),
                Format( 12, 2 )
            )
        )
    ),
    Add Table(
        Column Table(
            Analysis Columns(
                :height,
                Transform Column( "Log[height]", Formula( Log( :height ) ) )
            ),
            Statistics( Mean, "% of Total"n )
        ),
        Row Table( Grouping Columns( :sex ) )
    )
);

Show Chart

Syntax: obj << Show Chart( state=0|1 )

Description: Displays or hides a bar chart generated from the table created in Tabulate.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Show Chart( 1 );

Show Control

Syntax: obj << Show Control( state=0|1 )

Show Control Panel

Syntax: obj << Show Control Panel( state=0|1 )

Description: Displays or hides the control panel used to manipulate the table created in Tabulate. On by default.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Show Control Panel( 1 );

Show Shading

Syntax: obj << Show Shading( state=0|1 )

Description: Displays or hides alternating shaded and nonshaded lines on the table created in Tabulate. On by default.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Show Shading( 1 );

Show Table

Syntax: obj << Show Table( state=0|1 )

Description: Displays or hides the table created in Tabulate. On by default.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Show Table( 1 );

Show Test Build Panel

Syntax: obj << Show Test Build Panel( state=0|1 )

Description: Displays or hides the panel controlling sampling for a test build of the table.


dt = Open( "$SAMPLE_DATA/Cytometry.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Statistics( Mean, Std Dev ) ),
        Row Table( Analysis Columns( :ForSc, :SideSc, :CD3, :CD8, :CD4, :MCB ) )
    )
);
obj << Show Test Build Panel( 1 );

Show Tooltip

Syntax: obj << Show Tooltip( state=0|1 )

Description: Displays or hides the tooltips when hovering on drop zones and menus the Tabulate output.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Show Tool Tip( 1 );

Stack Grouping Columns

Syntax: Stack Grouping Columns(0 | 1)

Description: Stack the grouping columns into a single column, using indenting to show the nesting structure.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Show Control Panel( 0 ),
    Add Table(
        Column Table(
            Grouping Columns( :marital status ),
            Add Aggregate Statistics( :marital status ),
            Analysis Columns( :age ),
            Statistics( Min, Max )
        ),
        Row Table(
            Grouping Columns( :sex, :country, :size ),
            Add Aggregate Statistics( :sex, :country, :size ),
            Stack Grouping Columns( 1 )
        )
    )
);

Statistics

Syntax: Statistics( N|Mean|Std Dev|Min|Max|Range|% of Total|N Missing|N Categories|Sum|Sum Wgt|Variance|Std Err|CV|Median|Interquartile Range|Quantiles|Column %|Row %|All )

Description: Adds statistics to a column or row in the table. When scripting, the Statistics() message resides next to the identifying Analysis Columns( column ) message, and both are nested within either a Row Table() or Column Table() command.


dt = Open( "$SAMPLE_DATA/Cities.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Analysis Columns( :OZONE ), Statistics( Mean, Max ) ),
        Row Table( Grouping Columns( :Region ) )
    )
);

Test Build

Syntax: obj << Test Build( Sample Size( number ) )

Description: Displays the table using a test build sample of the data of size number.


dt = Open( "$SAMPLE_DATA/Cytometry.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Statistics( Mean, Std Dev ) ),
        Row Table( Analysis Columns( :ForSc, :SideSc, :CD3, :CD8, :CD4, :MCB ) )
    )
);
obj << Test Build( Sample Size( 100 ) );

Test Data View

Syntax: obj << Test Data View

Description: Displays the data table used as a sample to build the test table.


dt = Open( "$SAMPLE_DATA/Cytometry.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Statistics( Mean, Std Dev ) ),
        Row Table( Analysis Columns( :ForSc, :SideSc, :CD3, :CD8, :CD4, :MCB ) )
    )
);
obj << Test Build( Sample Size( 100 ) );
obj << Test Data View;

Undo

Syntax: obj << Undo

Description: Removes the effect of the last operation issued to the current table.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Add Table( Column Table( Grouping Columns( :type ) ) );
Wait( 2 );
obj << undo;

Uniform plot scale

Syntax: obj << Uniform plot scale( state=0|1 )

Description: Sets the scales for all subcategories to be the same on the bar chart. On by default.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Show Chart( 1 );
Wait( 2 );
obj << Uniform Plot Scale( 1 );

Unpack

Syntax: obj << Unpack( <Analysis columns | Statistics>(operand name, ...) )

Description: Unpacks a packed set of columns.


dt = Open( "$SAMPLE_DATA/Hybrid Fuel Economy.jmp" );
obj = dt << Tabulate(
    Show Control Panel( 0 ),
    Add Table(
        Column Table(
            Statistics( Sum ),
            Analysis Columns( :City MPG, :Hwy MPG, :Comb MPG ),
            Pack(
                Analysis Columns( City MPG, Hwy MPG, Comb MPG ),
                Template( "^FIRST  (^OTHERS)", "/" )
            )
        ),
        Row Table( Grouping Columns( :Mfr Name, :Engine ) )
    )
);
obj << Modify Table( Column Table( 1 ), Unpack( Analysis Columns( :City MPG ) ) );

Weight

Syntax: Weight( Column )

Description: Specify the weight column to be used in computing for statistics


dt = Open( "$SAMPLE_DATA/Car Physical Data.jmp" );
obj = dt << Tabulate(
    Show Control Panel( 0 ),
    Add Table(
        Column Table( Analysis Columns( :Horsepower ), Statistics( Mean ) ),
        Row Table( Grouping Columns( :Type ) )
    )
);
Wait( 1 );
obj << Weight( :Weight );

Shared Item Messages

Action

Syntax: obj << Action

Description: All-purpose trapdoor within a platform to insert expressions to evaluate. Temporarily sets the DisplayBox and DataTable contexts to the Platform.


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Bivariate(
    Y( :height ),
    X( :weight ),
    Action( Distribution( Y( :height, :weight ), Histograms Only ) )
);

Apply Preset

Syntax: Apply Preset( preset ); Apply Preset( source, label, <Folder( folder {, folder2, ...} )> )

Description: Apply a previously created preset to the object, updating the options and customizations to match the saved settings.

JMP Version Added: 18

Anonymous preset


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Oneway( Y( :height ), X( :sex ), t Test( 1 ) );
preset = obj << New Preset();
dt2 = Open( "$SAMPLE_DATA/Dogs.jmp" );
obj2 = dt2 << Oneway( Y( :LogHist0 ), X( :drug ) );
Wait( 1 );
obj2 << Apply Preset( preset );

Search by name


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Oneway( Y( :height ), X( :sex ) );
Wait( 1 );
obj << Apply Preset( "Sample Presets", "Compare Distributions" );

Search within folder(s)


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Oneway( Y( :height ), X( :sex ) );
Wait( 1 );
obj << Apply Preset( "Sample Presets", "t-Tests", Folder( "Compare Means" ) );

Automatic Recalc

Syntax: obj << Automatic Recalc( state=0|1 )

Description: Redoes the analysis automatically for exclude and data changes. If the Automatic Recalc option is turned on, you should consider using Wait(0) commands to ensure that the exclude and data changes take effect before the recalculation.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Automatic Recalc( 1 );
dt << Select Rows( 5 ) << Exclude( 1 );

Column Switcher

Syntax: obj << Column Switcher(column reference, {column reference, ...}, < Title(title) >, < Close Outline(0|1) >, < Retain Axis Settings(0|1) >, < Layout(0|1) >)

Description: Adds a control panel for changing the platform's variables


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Contingency( Y( :size ), X( :marital status ) );
ColumnSwitcherObject = obj << Column Switcher(
    :marital status,
    {:sex, :country, :marital status}
);

Copy Script

Syntax: obj << Copy Script

Description: Create a JSL script to produce this analysis, and put it on the clipboard.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Copy Script;

Data Table Window

Syntax: obj << Data Table Window

Description: Move the data table window for this analysis to the front.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Data Table Window;

Get By Levels

Syntax: obj << Get By Levels

Description: Returns an associative array mapping the by group columns to their values.

JMP Version Added: 18


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
biv = dt << Bivariate( X( :height ), Y( :weight ), By( :sex ) );
biv << Get By Levels;

Get Container

Syntax: obj << Get Container

Description: Returns a reference to the container box that holds the content for the object.

General


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
t = obj << Get Container;
Show( (t << XPath( "//OutlineBox" )) << Get Title );

Platform with Filter


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
gb = Graph Builder(
    Show Control Panel( 0 ),
    Variables( X( :height ), Y( :weight ) ),
    Elements( Points( X, Y, Legend( 1 ) ), Smoother( X, Y, Legend( 2 ) ) ),
    Local Data Filter(
        Add Filter(
            columns( :age, :sex, :height ),
            Where( :age == {12, 13, 14} ),
            Where( :sex == "F" ),
            Where( :height >= 55 ),
            Display( :age, N Items( 6 ) )
        )
    )
);
New Window( "platform boxes",
    H List Box(
        Outline Box( "Report(platform)", Report( gb ) << Get Picture ),
        Outline Box( "platform << Get Container", (gb << Get Container) << Get Picture )
    )
);

Get Data Table

Syntax: obj << Get Data Table

Description: Returns a reference to the data table.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
t = obj << Get Datatable;
Show( N Rows( t ) );

Get Script

Syntax: obj << Get Script

Description: Creates a script (JSL) to produce this analysis and returns it as an expression.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
t = obj << Get Script;
Show( t );

Get Script With Data Table

Syntax: obj << Get Script With Data Table

Description: Creates a script(JSL) to produce this analysis specifically referencing this data table and returns it as an expression.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
t = obj << Get Script With Data Table;
Show( t );

Get Timing

Syntax: obj << Get Timing

Description: Times the platform launch.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
t = obj << Get Timing;
Show( t );

Get Web Support

Syntax: obj << Get Web Support

Description: Return a number indicating the level of Interactive HTML support for the display object. 1 means some or all elements are supported. 0 means no support.


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Bivariate( Y( :Weight ), X( :Height ) );
s = obj << Get Web Support();
Show( s );

Get Where Expr

Syntax: obj << Get Where Expr

Description: Returns the Where expression for the data subset, if the platform was launched with By() or Where(). Otherwise, returns Empty()

JMP Version Added: 18


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
biv = dt << Bivariate( X( :height ), Y( :weight ), By( :sex ) );
biv2 = dt << Bivariate( X( :height ), Y( :weight ), Where( :age < 14 & :height > 60 ) );
Show( biv[1] << Get Where Expr, biv2 << Get Where Expr );

Ignore Platform Preferences

Syntax: Ignore Platform Preferences( state=0|1 )

Description: Ignores the current settings of the platform's preferences. The message is ignored when sent to the platform after creation.


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Bivariate(
    Ignore Platform Preferences( 1 ),
    Y( :height ),
    X( :weight ),
    Action( Distribution( Y( :height, :weight ), Histograms Only ) )
);

Local Data Filter

Syntax: obj << Local Data Filter

Description: To filter data to specific groups or ranges, but local to this platform


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
dt << Distribution(
    Nominal Distribution( Column( :country ) ),
    Local Data Filter(
        Add Filter( columns( :sex ), Where( :sex == "Female" ) ),
        Mode( Show( 1 ), Include( 1 ) )
    )
);

New JSL Preset

Syntax: New JSL Preset( preset )

Description: For testing purposes, create a preset directly from a JSL expression. Like <<New Preset, it will return a Platform Preset that can be applied using <<Apply Preset. But it allows you to specify the full JSL expression for the preset to test outside of normal operation. You will get an Assert on apply if the platform names do not match, but that is expected.

JMP Version Added: 18


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Oneway( Y( :Height ), X( :Age ) );
preset = obj << New JSL Preset( Oneway( Y( :A ), X( :B ), Each Pair( 1 ) ) );
Wait( 1 );
obj << Apply Preset( preset );

New Preset

Syntax: obj = New Preset()

Description: Create an anonymous preset representing the options and customizations applied to the object. This object can be passed to Apply Preset to copy the settings to another object of the same type.

JMP Version Added: 18


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Oneway( Y( :height ), X( :sex ), t Test( 1 ) );
preset = obj << New Preset();

Paste Local Data Filter

Syntax: obj << Paste Local Data Filter

Description: Apply the local data filter from the clipboard to the current report.


dt = Open( "$SAMPLE_DATA/Cities.jmp" );
dist = Distribution( Continuous Distribution( Column( :POP ) ) );
filter = dist << Local Data Filter(
    Add Filter( columns( :Region ), Where( :Region == "MW" ) )
);
filter << Copy Local Data Filter;
dist2 = Distribution( Continuous Distribution( Column( :Lead ) ) );
Wait( 1 );
dist2 << Paste Local Data Filter;

Redo Analysis

Syntax: obj << Redo Analysis

Description: Rerun this same analysis in a new window. The analysis will be different if the data has changed.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Redo Analysis;

Relaunch Analysis

Syntax: obj << Relaunch Analysis

Description: Opens the platform launch window and recalls the settings that were used to create the report.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Relaunch Analysis;

Remove Column Switcher

Syntax: obj << Remove Column Switcher

Description: Removes the most recent Column Switcher that has been added to the platform.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Contingency( Y( :size ), X( :marital status ) );
ColumnSwitcherObject = obj << Column Switcher(
    :marital status,
    {:sex, :country, :marital status}
);
Wait( 2 );
obj << Remove Column Switcher;

Remove Local Data Filter

Syntax: obj << Remove Local Data Filter

Description: If a local data filter has been created, this removes it and restores the platform to use all the data in the data table directly


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
dist = dt << Distribution(
    Nominal Distribution( Column( :country ) ),
    Local Data Filter(
        Add Filter( columns( :sex ), Where( :sex == "Female" ) ),
        Mode( Show( 1 ), Include( 1 ) )
    )
);
Wait( 2 );
dist << remove local data filter;

Render Preset

Syntax: Render Preset( preset )

Description: For testing purposes, show the platform rerun script that would be used when applying a platform preset to the platform in the log. No changes are made to the platform.

JMP Version Added: 18


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Oneway( Y( :Height ), X( :Age ) );
obj << Render Preset( Expr( Oneway( Y( :A ), X( :B ), Each Pair( 1 ) ) ) );

Report

Syntax: obj << Report;Report( obj )

Description: Returns a reference to the report object.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
r = obj << Report;
t = r[Outline Box( 1 )] << Get Title;
Show( t );

Report View

Syntax: obj << Report View( "Full"|"Summary" )

Description: The report view determines the level of detail visible in a platform report. Full shows all of the detail, while Summary shows only select content, dependent on the platform. For customized behavior, display boxes support a <<Set Summary Behavior message.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Report View( "Summary" );

Save Script for All Objects

Syntax: obj << Save Script for All Objects

Description: Creates a script for all report objects in the window and appends it to the current Script window. This option is useful when you have multiple reports in the window.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Save Script for All Objects;

Save Script for All Objects To Data Table

Syntax: obj << Save Script for All Objects To Data Table( <name> )

Description: Saves a script for all report objects to the current data table. This option is useful when you have multiple reports in the window. The script is named after the first platform unless you specify the script name in quotes.

Example 1


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
dt << New Column( "_bycol",
    Character,
    Nominal,
    set values( Repeat( {"A", "B"}, N Rows( dt ) )[1 :: N Rows( dt )] )
);
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    ),
    By( _bycol )
);
obj[1] << Save Script for All Objects To Data Table;

Example 2


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
dt << New Column( "_bycol",
    Character,
    Nominal,
    set values( Repeat( {"A", "B"}, N Rows( dt ) )[1 :: N Rows( dt )] )
);
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    ),
    By( _bycol )
);
obj[1] << Save Script for All Objects To Data Table( "My Script" );

Save Script to Data Table

Syntax: Save Script to Data Table( <name>, < <<Prompt(0|1)>, < <<Replace(0|1)> );

Description: Create a JSL script to produce this analysis, and save it as a table property in the data table.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Save Script to Data Table( "My Analysis", <<Prompt( 0 ), <<Replace( 0 ) );

Save Script to Journal

Syntax: obj << Save Script to Journal

Description: Create a JSL script to produce this analysis, and add a Button to the journal containing this script.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Save Script to Journal;

Save Script to Report

Syntax: obj << Save Script to Report

Description: Create a JSL script to produce this analysis, and show it in the report itself. Useful to preserve a printed record of what was done.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Save Script to Report;

Save Script to Script Window

Syntax: obj << Save Script to Script Window

Description: Create a JSL script to produce this analysis, and append it to the current Script text window.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Save Script to Script Window;

SendToByGroup

Syntax: SendToByGroup( {":Column == level"}, command );

Description: Sends platform commands or display customization commands to each level of a by-group.


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Distribution(
    By( :Sex ),
    SendToByGroup(
        {:sex == "F"},
        Continuous Distribution( Column( :weight ), Normal Quantile Plot( 1 ) )
    ),
    SendToByGroup( {:sex == "M"}, Continuous Distribution( Column( :weight ) ) )
);

SendToEmbeddedScriptable

Syntax: SendToEmbeddedScriptable( Dispatch( "Outline name", "Element name", command );

Description: SendToEmbeddedScriptable restores settings of embedded scriptable objects.



dt = Open( "$SAMPLE_DATA/Reliability/Fan.jmp" );
dt << Life Distribution(
    Y( :Time ),
    Censor( :Censor ),
    Censor Code( 1 ),
    <<Fit Weibull,
    SendToEmbeddedScriptable(
        Dispatch(
            {"Statistics", "Parametric Estimate - Weibull", "Profilers", "Density Profiler"},
            {1, Confidence Intervals( 0 ), Term Value( Time( 6000, Lock( 0 ), Show( 1 ) ) )}
        )
    )
);

SendToReport

Syntax: SendToReport( Dispatch( "Outline name", "Element name", Element type, command );

Description: Send To Report is used in tandem with the Dispatch command to customize the appearance of a report.


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Distribution(
    Nominal Distribution( Column( :age ) ),
    Continuous Distribution( Column( :weight ) ),
    SendToReport( Dispatch( "age", "Distrib Nom Hist", FrameBox, {Frame Size( 178, 318 )} ) )
);

Sync to Data Table Changes

Syntax: obj << Sync to Data Table Changes

Description: Sync with the exclude and data changes that have been made.


dt = Open( "$SAMPLE_DATA/Cities.jmp" );
dist = Distribution( Continuous Distribution( Column( :POP ) ) );
Wait( 1 );
dt << Delete Rows( dt << Get Rows Where( :Region == "W" ) );
dist << Sync To Data Table Changes;

Title

Syntax: obj << Title( "new title" )

Description: Sets the title of the platform.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
obj << Title( "My Platform" );

Top Report

Syntax: obj << Top Report

Description: Returns a reference to the root node in the report.


dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
    Add Table(
        Column Table( Grouping Columns( :sex, :marital status ) ),
        Row Table( Grouping Columns( :country, :size ) )
    )
);
r = obj << Top Report;
t = r[Outline Box( 1 )] << Get Title;
Show( t );

View Web XML

Syntax: obj << View Web XML

Description: Returns the XML code that is used to create the interactive HTML report.


dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
obj = dt << Bivariate( Y( :Weight ), X( :Height ) );
xml = obj << View Web XML;