Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

For more information on how the platform calculates variance, see VAR Function.

D s
snippetBasic

VARIF
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextpivot value:
varif(testScores, ((testScores > 0) && (testScores < 90)) group:studentId limit:1

...

varif(testScores, ((testScores > 0) && (testScores < 90))

Output: Returns the variance of the testScores

...

 column when the testScores value is between 0 and 90.

...

D s
snippetSyntax

VARIF
d-codelang-syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextpivot value:
varif(col_ref, test_expression) [group:group_col_ref] [limit:limit_count]

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


ArgumentRequired?Data TypeDescription
col_refYstringReference to the column you wish to evaluate.
test_expressionYstringExpression that is evaluated. Must resolve to true or false

...