...
| Info |
|---|
You can drag a column from the column list and drop it into one of the expression boxes. Column expression will be correctly transformed into processing form. This behavior is implemented in the unique values list too. Predefined functions can be dragged and dropped into the calculation expression box. |
| Drawio | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
# | Component | Description |
1 | List of columns | List of columns available for expression construction. For inserting the expression you can drag the list item and drop it into one of the expression boxes or just double-click on the name and the column will be added to the expression with the cursor in the right form. |
2 | New | Opens the dialog for creating a new column in the dataset. |
Delete | Removes selected columns from the dataset | |
3 | Expression box for calculation | Insert expression for calculation. The calculation will be applied to selected records only or all records. Below the expression box are buttons with operands. |
4 | Expression buttons | Click on the buttons to insert symbols in the expression box |
Clear | Clears expression field | |
5 | Functions | List of predefined functions which are possible to use in expression boxes |
6 | Table view | The table view shows selected records - highlighted by yellow color. The table view includes a context menu with functions for manual selection and deselection of records. |
7 | Clear selection | Clears selected records |
8 | Calculate | Launch calculation |
9 | Describe column | Describe column opens and expands the Column description section. All unique values in the column are listed. This can be used to see all existing flag columns. Values are often used in a calculation or selection expression. Users can drag & drop or double-click the value. Basic statistics are displayed at the bottom of the Column description section. (see screenshot below) |
10 | Switch selection | Invert selection. Selected points are deselected and not selected points are selected. |
11 | Selected records only | Show/hide not selected rows for better readability. |
12 | Save | Save changes |
13 | Close | Close calculator window |
...
Useful calculation expressions
...