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 a version of this function computed over a rolling window of rows, see ROLLINGMODE Function.

D s
snippetBasic

MODE
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextpivot value:
mode(count_visits) group:postal_code limit:1

...

mode(count_visits)

Output: Returns the mode of the values in the count_visits column for the postal_code value. The limit parameter defines the maximum number of output columns.

D s
snippetSyntax

MODE
d-codelang-syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextpivot value:
mode(function_col_ref) [group:group_col_ref] [limit:limit_count]

mode(function_col_ref) [group:group_col_ref] [limit:limit_count]


ArgumentRequired?Data TypeDescription
function_col_refYstringName of column to which to apply the function

...