Could you share some sample data or a workbook with sample data to see if can give you a solution?
I feel that you have to give more information about your scenario and requirement in order to facilitate any helper to find a solution for you.
I have a some questions: do you need to represent answers per individuals, I mean, to have a row with liker scores per participant in the survey or to present summarized scores per group of persons? What is the meaning of the percentage at the bottom of you sketch?
Again, a workbook with sample data will help us to find a better solution to your requirement.
I've attached the sample data that I made up.
I posted a picture above that shows how the colors need to work. 3+ and they are green and everything else would be red and what you see there is one survey. The 100% numbers at the bottom represent the total number of surveys for that SVP. Basicly it's one point if it's above a 3 and none if it is 3 or below. So they are all 100% here but if Timeliness had another survey below it and if that score was a 1 then the timeliness total would drop to 50%.
Survey Questions Sample.twb 4.4 KB