...
For a version of this function computed over a rolling window of rows, see ROLLINGMODE Function.
| d-codelang-syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | pivot value: |
|---|
| MODE| mode(count_visits) group:postal_code limit:1 |
|
mode(count_visits) |
Output: Generates a two-column table containing the unique values from the postal_code column and the 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-code-lang-syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | pivot value |
|---|
| :MODE| :mode(function_col_ref) [group:group_col_ref] [limit:limit_count] |
|
mode(function_col_ref) [group:group_col_ref] [limit:limit_count] |
| Argument | Required? | Data Type | Description |
|---|
| function_col_ref | Y | string | Name of column to which to apply the function |
...
