I created a survey that was originally supposed to feed into tableau so it was set up in a way that made the most visual sense for the internal team that was going to be filling it out. I now need to turn it into a dashboard within the Qualtrics system as well and I am having a hard time figuring out the best way to do this that is not going to be totally time consuming to set up on the backend. 

We have 8 internal employees that are going to be filling this out on a regular basis, each employee has their own set of clients ranging from 2-15 per person. They are rating their clients on a Green, Yellow, Red scale in four categories. I have assigned numeric values to each of the colors ‘

Green = 25

Yellow = 20

Red = 5

 This is an example of the questions layout, the black lines are each represent a client 

What I am running into is with this structure of question instead of pulling the data out as 

Client one ( emotional sentiment rating, perception of value rating, feedback tone and content rating and experience consistency rating)

It is going Emotional sentiment (client 1, client , client 3, client 4) and breaking it out that way 

I need a way to combine all four rating together for each client as all four values affect the overall score. 

I know that I can do a custom metric within the dashboard itself or I can use a formula in the embedded data, I am a little less familiar with embedded data though and I am not sure if there is a way that I could do this across the board for each client without having to go in and individually set either the custom metric or embedded data.

From what I have researched it does not seem like that is something I can do and I would need to combine ES + PV T FT&C + EC for each client we have in this survey. 

Would love to know if anyone has any ideas on how to not have to do that, if that is even possible or a way to successfully visualize the data as is without having to do any of the above.