STDEVIF Function

D toc

Excerpt
Generates the standard deviation of values by group in a column that meet a specific condition.

Info
NOTE: When added to a transform, this function is applied to the sample in the data grid. If you change your sample or run the job, the computed values for this function are updated. Transforms that change the number of rows in subsequent recipe steps do not affect the values computed for this step.

D s terms

area	stat_sampling

This function is calculated across the entire population.
For more information on a sampled version of this function, see STDEVSAMPIF Function.

D s lang vs sql

D s

snippet	Basic

D lang syntax

RawWrangle	true
Type	ref
showNote	true
WrangleText	pivot value: stdevif(testScores, testScores > 0) group:studentId limit:1

stdevif(testScores, testScores > 0)

Output: Returns the standard deviation of the testScores column when the testScores value is greater than 0.

D s

snippet	Syntax

D lang syntax

RawWrangle	true
Type	syntax
showNote	true
WrangleText	pivot value:stdevif(col_ref, test_expression) [group:group_col_ref] [limit:limit_count]

stdevif(col_ref, test_expression) [group:group_col_ref] [limit:limit_count]

Argument	Required?	Data Type	Description
col_ref	Y	string	Reference to the column you wish to evaluate.
test_expression	Y	string	Expression that is evaluated. Must resolve to `true` or `false`

D s lang notes

For more information on the group and limit parameters, see Pivot Transform.

Name of the column whose values you wish to use in the calculation. Column must be a numeric (Integer or Decimal) type.

D s

snippet	usage

Required?	Data Type	Example Value
Yes	String that corresponds to the name of the column	`myValues`

This parameter contains the expression to evaluate. This expression must resolve to a Boolean (true or false) value.

D s

snippet	usage

Required?	Data Type	Example Value
Yes	String expression that evaluates to `true` or `false`	`(LastName == 'Mouse' && FirstName == 'Mickey')`

D s

snippet	Examples

Include Page

	EXAMPLE - Conditional Calculations Functions
	EXAMPLE - Conditional Calculations Functions

D s also

label	aggregate

Versions Compared