In Trevor.io, you can use the Summarize step to perform aggregate functions.
To count distinct values, simply:
- Add a Summarize step
- Click the metric button that appears.
- Select Count from the dropdown.
- Choose the column whose values you want to count.
All the options, with the exception of row count, will count the unique values in the column.
Please sign in to leave a comment.