The users on my website have an integer field My medals, which can contain an unlimited amount of values, representing nids from nodes of the type Medal. Every Medal node contains one term of the taxonomy Colour (either Gold, Silver and Bronze).
Given a certain uid, I would like to create a View that shows the total number of nodes per taxonomy term, based on the user's field My medals.
Example. Suppose the nodes with nids 1, 2 and 3 have a Gold term, the node with nid 4 has a Silver term, and the node with nid 5 has a Bronze term. Let user 1 have a My medals field with values 1, 2, 4, 5. Then the View should return "Gold: 2, Silver: 1, Bronze: 1" when the uid 1 is given.