Forum Discussion
Solved
Overlapping Products
Hi I have a requirement wherein I want to count distinct employeeId for the products. For example, from the sample data below, 2nd snap is the sort of required output. If we look at the output h...
see attached. Can probably be simplified.
Thanks for your response !!
I have added the sample data however I am not certain which visual we can use to show data in the output format but I was thinking if we can use Matrix. Please suggest if we can present this data in any other visual more efficiently.
| EmployeeId | Product |
| E1111 | Product_1 |
| E1111 | Product_2 |
| E1111 | Product_3 |
| E1222 | Product_1 |
| E1222 | Product_2 |
| E1222 | Product_3 |
| E1222 | Product_4 |
| E1223 | Product_2 |
| E1223 | Product_3 |
| E1223 | Product_4 |
see attached. Can probably be simplified.