Page tree

Versions Compared


  • 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 counting of distinct non-nulls without conditionals, use the COUNTDISTINCT function. See COUNTDISTINCT Function.

D s

D code

pivot value: COUNTDISTINCTIF(entries, entryValidation == 'Ok') group:City limit:1

Output: Generates a two-column table containing the unique values for City and the count of distinct non-null values in the entries column for that City value when the entryValidation value is 'Ok'. The limit parameter defines the maximum number of output columns.

D s

D code

pivot value:COUNTDISTINCTIF(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