Hi, What is the best way to count the number of di...
# gooddata-platform
j
Hi, What is the best way to count the number of distinct (column 1, column 2) couple ?
j
You can try following approach: Use sub-metric which returns 1 for each couple and sum aggregation function.
Copy code
select sum(select 1 by column1, column2)
You can also consider introducing new attribute for this purpose in logical data model (e.g. full name defined as concatenated first_name and last_name).