Easy Insight Logo
Call 1-(720)-316-8174

Math Functions

quartile returns the quartile of the selected value relative to all other values of the field in the report.

quartile([Customer], [Metric]")

would calculate the quartile for Metric for each unique value of Customer in the report.

stddev returns the standard deviation of the field.

stddev([SalesPerson], [Metric])

would calculate the standard deviation of Metric for each distinct SalesPerson in the data. By itself, this script may not give you quite what you need, since Metric might already be summarized per SalesPerson by the time the calculation is evaluated. In order to make sure it runs correctly, you might instead want to try:

notnull([Sales ID], stddev([SalesPerson], [Metric]))

The above script makes sure that data is still broken out per sales ID when it calculates standard deviation, ensuring that the calculation is properly at the row level.

If you want to see the standard deviation for your entire data set, you can also simply do:

notnull([Sales ID], stddev([Metric])

sum

sum returns the sum of Metric for all rows in the report.

sum([[Metric])

would calculate the sum for Metric across all rows in the report.

sum([[Metric], [Region])

would calculate the sum for Metric per unique Region in the data.

RESOURCES
Twitter Logo