You can define a subset of rows using a selection expression, a mathematical formula that evaluates to 1 (true) or 0 (false).

Enter a selection expression to define a subset of rows.

Only those rows for which the selection expression evaluates to true will be displayed. Also, if you summarize the data, only the selected rows will be included in the summary.
Note: The selection applies only to your current workspace and does not affect the original table.

To select rows by entering a selection expression:

  1. In the New operation panel, click Select.
    The 1010data Insights Platform displays the Simple comparisons fields and options in the Select rows panel.

  2. Clear the Simple Comparisons checkbox.
    The Insights Platform displays the Expression Editor view.

  3. In the Expression Editor, enter a selection expression.
    The selection expression may refer to one or more columns and may include standard arithmetic, relational, and logical operators as well as any Insight Platform functions.
    Note: When entering a column in an expression, use the column name as opposed to the column heading.
    For example, to select rows where the transaction ID (transid) is between 535 and 540, use the selection expression between(transid;535;540).

    For more information, see Writing Expressions in the 1010data Reference Manual. For more information about the Expression Editor, see Expression Editor.

  4. Click the Submit operation () icon.
    The Insights Platform displays the results of your selection in the grid.