It sounds like you could use a calculation to determine the 'color' for each country. The calculation could either return a normalized numeric value (encoding by the numeric data would give you different ranges = different colors), or a 'red', 'green', etc. text string based on the calculation.
But, a detailed answer really depends on what your data table looks like and how the values are calculated. Can you share some of your data or the method for calculating the value that would be used for color filtering? It's difficult to figure out what the calculation would look like without knowing much about the data.
Hi Michael, it would be easier to offer suggestions if you had sample data in an attached twbx, but one thought is to use a metric other than <avg value> to color the chart; something that shows distance between the average and the requirement. One possibility is to calculate the % above/below average: (<avg value> / <requirement>)-1.
Hope that helps,