Column Selector
A combo box for selecting a column
Mouse-over to see column summary, as well as a viewer preview. Drag a column into a selector to change it. Start typing to filter columns. Esc to reset column filter, or hide popup. Enter to accept current choice. Space to pop up column selector.
Using a formula instead of a column
A column property can be given a formula rather than an existing column. Open the
Context Panel, find the property, and click the
plus icon on its row to open Add New Column, then write an
expression such as ${AGE} * 2. On a scatter plot the Color selector carries the same icon
directly on the plot.
The result is stored as a hidden column, so it does not clutter the grid, and it is shared: once defined, the same formula can be picked from any other selector on that table. To change it, select it and click the pencil icon — the formula is edited in place, so every viewer using it updates. To keep the original and add a variant, select a regular column first and use the plus icon again.
Formula columns are listed at the end of the column picker.
See also: