var()

Returns the variance of the values in a field. Accepts measure fields as input but not expressions.

1q = load "DTC_Opportunity_SAMPLE";
2q = group q by all;
3q = foreach q generate var('Amount') as 'var_Amount';

See Also

• varp()

j

Overview

Quick Start

Examples

SAQL Reference

SAQL Basic Elements

SAQL Operators

SAQL Statements

SAQL Functions

Aggregate Functions

avg() or average()

count()

first()

last()

max()

median()

min()

sum()

unique()

stddev()

stddevp()

var()

varp()

percentile_cont()

percentile_disc()

regr_intercept()

regr_slope()

regr_r2()

grouping()

Date Functions

Time Zone Date Functions

Work with Custom Fiscal Year Data

String Functions

Math Functions

Windowing Functions

coalesce

Query Performance

Previous Versions