Number from Column

The Number from Column global variable allows you to extract values or summary statistics from a column of data.

When you create a Number from Column variable, you have to specify the column of data you want to use and the type of value you want to display.

How to Create

Create a Number from Column variable using the Other menu in the variables section.

This will create the variable with a red dot in the corner, indicating that you need to select a column and name the variable.

For a shortcut, click the gear menu on a column object and select from the menu along with what you want to calculate (sum, max, min, … ).

The shortcut menu is also available by control-clicking on a column header in the data table.

Display in a Graph

To display in a graph, clicking the “+” symbol to the right of any text entry box and select from the drop-down menu. This will add a token.

Column Menu

From the Column menu, select or change the column from which values are derived.

What Menu

Use the What menu to specify the value you want to derive or return.

sumsum of all values
sum of ^2sum of the squares of the values
maxmaximum of a column
minminimum of the column
maxmaximum of a column
rangemaximum minus the minimum
countNumber of non-empty rows
# of rowsTotal number of rows (including empty)
meanMean of the column
medianMedian of the column
σPopulation Standard deviation
sSample Standard deviation (unbiased estimate of σ)
semStandard error of the mean
At index …Return a value from a specific row

At Index …

You can also extract a single numeric value from a row by specifying the index for the row. This feature can be useful for animations or scrubbing through a data set with a slider.

To use, set the index to a slider variable and restrict that to an integer.

Then the slider could be used to scrub through the rows.

Notice how the value changes when we move the slider.

Related Articles