If you need to add more than one column to a data function
calculation or to an axis in a visualization, you click
Select columns to show a dialog where you can pick
all columns that should be included.
Procedure
-
In the flyout when configuring a data function, first select the
Data table to pick columns from, then click
Select columns.
In the context of visualizations, you can instead reach the
Select columns dialog by right-clicking on an
axis selector (where applicable), either directly in the visualization or from
the visualization properties, and choose
Select columns from the pop-up menu.
-
In the
Select columns dialog, in the
Available columns field, select the columns
that you want to include.
You can use the search field to limit the number of columns shown
in the list. Use Ctrl + click to choose more than one column directly, or click
and drag with the mouse pointer to choose many columns in a sequence.
-
Click
Add to add the columns to the
Selected columns list.
-
If desired, repeat steps 2 and 3.
-
In some cases, the order of the selected columns is important for
the outcome. Click to choose one or more columns in the
Selected columns list and click
Move up or
Move down to move them to the desired order.
-
Click
OK (or
Close) when you are done.