Hi,
I need help creating a visualization showing the count of service reps assigned to each customer as well as being able to show which reps.
I have a table containing one column “customer name” and then several other columns showing service reps related to that client. See below
Customer Name | Service Rep 1 (Tom) | Service rep 2 (Dick) | Service Rep 3 (Harry) | Service Rep 4 (Michael) | Service Rep 5 (Scott) | Service Rep 6 (Dwight) |
McDonalds | x | | | x | x | |
Burger King | x | x | | | x | |
Wendy’s | | | x | | | X |
Ideally would like to select a customer (ex. McDonalds) and be able to see that it has 3 reps and be able to see that they are Tom, Michael, and Scott.
I was thinking to just do a chart and show a yes now but in my actual data i have much more then was
Appreciate any advice on how to display this.
