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.
To select rows by entering a selection expression:
- In the New operation panel, click Select. The 1010data Insights Platform displays the Simple comparisons fields and options in the Select rows panel.
- Clear the Simple Comparisons checkbox. The Insights Platform displays the Expression Editor view.
- 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.
- Click the Submit operation () icon. The Insights Platform displays the results of your selection in the grid.