Forum Discussion
Counting unique values by condition
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.
1 Reply
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
