I would like to count a column called "ID" based on the criteria of another column "Color". The problem is, I have another table that is associated and has the same "ID", but multiple instances because it has another field called "ROLE".
I would like to count the UNIQUE "ID"s based for "Color" = "RED". It is actually the word "RED", so text.
The table below would yield 3 and 50%. How can I do this? I am trying to use the KPI chart.
