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

...

To perform a simple count of rows without conditionals, use the COUNT function. See COUNT Function.

D s
snippetBasic

COUNTIF
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextpivot value:
countif(failed_deliveries >= 10) group:postal_code limit:1

...

countif(failed_deliveries >= 10)

Output: Returns the count of records in which the value of the failed_deliveries column is greater than or equal to 10.

...

D s
snippetSyntax

COUNTIF
d-codelang-syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextpivot value:
countif(test_expression) [group:group_col_ref] [limit:limit_count]

countif(test_expression) [group:group_col_ref] [limit:limit_count]


ArgumentRequired?Data TypeDescription
test_expressionYstringExpression that is evaluated. Must resolve to true or false

...