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.

Name	Description
sum	sum of all values
sum of ^2	sum of the squares of the values
max	maximum of a column
min	minimum of the column
max	maximum of a column
range	maximum minus the minimum
count	Number of non-empty rows
# of rows	Total number of rows (including empty)
mean	Mean of the column
median	Median of the column
σ	Population Standard deviation
s	Sample Standard deviation (unbiased estimate of σ)
sem	Standard 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.