Count distinct, also sometimes referred to as 'count unique' is a function that allows you to count the distinct values of a particular column.
E.g. if you have a query with customers & reservations, you might want to know how many individual reservations were made. You can do this as follows:
- Add a Summarize step, and click the + next to Metrics.
- Hover over count and then scroll down to the section where it says 'Count distinct'
- Select the column that you want to get distinct values for
Using 'count distinct' can be a great way to remove duplicates in your query, because you can just see how many unique values there are.
Please sign in to leave a comment.