Calculate

<< Click to Display Table of Contents >>

Navigation:  Using StreamLab > StreamLab Guides Overview > Guide Commands > Analytics >

Calculate

Previous pageReturn to chapter overviewNext page

The Calculate command lets you perform an arithmetical calculation on a column. Use @ for the value of the column. Selected columns must have numerical values, such as DOUBLE.

Calculations might be something like the following:

@+2000

Adds 2000 to the column value.

@-800

Subtracts 800 from the column value.

@/2

Divides the column value by 2.

@*4

Multiplies the column value by 4.

To implement a Calculate command:

1.Select column(s) to which to apply categories. Each column must contain numerical data.

2.Enter an arithmetical calculation for the column.

3.Click the + icon  in the Suggestions list to add the command to the Guide script.

4.The results of the script appear in the Output View window.

sl_calculate