Approximate Count Distinct function in calculated metrics

Last update: 2023-06-28
  • Created for:
  • Beginner
    User

Learn how to create a calculated metric using the Approximate Count Distinct function, which returns the approximated distinct count of dimension items for a selected dimension.

You can use the metric shown in this video in any report to understand the count of one dimension against values of other. A very common use case would be to use this function to create a Customer IDs metric, which you could then use in any report to see how many customers apply to the different dimension values.

On this page