hello everyone, I want to create a chart that breaks down by credit card and the metric is the number of customers with transactions. The problem is that I have the following table:
Credit Card | id_num | transaction_date |
Credit Card1 | 10 | 01-01-2023 |
Credit Card1 | 10 | 01-01-2023 |
Credit Card2 | 13 | null |
Credit Card3 | 12 | 01-02-2023 |
as you can see in the table, the customers are repeated. How can I create a parameter or make it count only the customers with transactions and avoid repetitions?