Counting unique values by condition

[Anonymous]

Hello together, 

I have a table like this 

Planner	Supplier
1	Siemens
1	Müller
1	Siemens
2	Müller
3	Siemens
3	Müller
3	Müller
3	Müller
4	Siemens
4	Koch

I have different Planners and they have used different suppliers. I want to count the unique Suppliers depending on the Planner. My Target is to get the following Output: 

Planner	Different Supplier used
1	2
2	1
3	2
4	2

So I need to count unique suppliers by Planner. 

Thanks for your help.

[barritown]

Hi @Anonymous,

You can do it without any code.

1. Add a table visual.

2. Add both columns to its "Values" field.

3. Choose "Don't summarize" for Planner.

4. Choose "Count (Distinct)" for Supplier.

The output should be like this:

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian