Need help on finding a way to visualize this data

scootzinc — Thu, 09 Jun 2022 14:21:22 GMT

I have a table that essentially looks like this:

SUPPLIER	CC#	Y/N
Supplier X	132-04-002	Y
Supplier W	132-03-001	N
Supplier W	132-04-007	Y
Supplier W	132-03-003	N
Supplier W	132-03-001	Y
Supplier X	132-04	Y
Supplier X	132-01-001	Y
Supplier W	132-02-001	Y
Supplier Y	132-03-001	N
Supplier X	132-04-005	Y
Supplier Y	132-04-007	N
Supplier X	132-04-005	N
Supplier Z	132-04-001	Y
Supplier W	132-01	N
Supplier Z	132-04-005	N
Supplier W	132-04-007	Y
Supplier W	132-03-003	N
Supplier Y	132-04-004	N
Supplier W	132-01-002	N
Supplier W	132-01-002	N
Supplier Z	132-01-003	Y
Supplier X	132-01-004	Y
Supplier Z	132-02-002	N
Supplier Y	132-01-003	Y
Supplier X	132-02	Y
Supplier X	132-04	N
Supplier Y	132-03-003	N

Essentially, I'd like to find a way to display the suppliers across the Y access, the CC# across the X access and only include the "y" values (which can be replaced by a number value if it makes displaying it easier). I'd like to have it feature something like the ribbon visualisation where it connects suppliers from x value to x value. In a correlation chart, this would like essentially be like a table where there is a color where there would be a "Y" value and nothing where there is a "N" value. The idea is to be able to easily identify where suppliers offer certain capabilities so that I can easily see where they overlap. Ideally, I'd add another column that indicates the amount of spend we have with a supplier in that capability. So that I can see where we might be able to consolidate spend and reduce our number of suppliers... Does that make sense?

topic Need help on finding a way to visualize this data in Custom Visuals Development Discussion

Need help on finding a way to visualize this data