How could I assign multiple separate values to a colour attribute
I'm working on a new Magento 2 EE build and my colleague and I have come across an attribute data scenario we're not sure how best to tackle.
Imagine setting up a standard Colour attribute with Multiple-select to assign colour information to something like a cushion. If you picture a Union Flag cushion being added to the inventory, the Store user would assign Blue, White and Red colours via multiple select.
What we need to also do is assign an additional value to each selection to roughly apply the percentage of each colour in that product. i.e. the cushion might be 40% blue, so that we can use this data later on to prioritise products when filtering by colour to show the highest percentages of the selected colour first.
Would really appreciate people's input on the best way to achieve this in a user-friendly way for the CMS to be as simple as possible.