...
To perform a simple summing of rows without conditionals, use the SUM function. See SUM Function.
| d-code-lang-syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | pivot value: |
|---|
| SUMIF| sumif(timeoutSecs, errors >= 1) group:serverAddress limit:1 |
|
...
sumif(timeoutSecs, errors >= 1) |
Output: Returns the sum of the timeoutSecs
...
column when the errors value is greater than or equal to 1.
...
| d-codelang-syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | pivot value: |
|---|
| SUMIF| sumif(col_ref, test_expression) [group:group_col_ref] [limit:limit_count] |
|
sumif(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 |
...
