4 Replies Latest reply on Dec 30, 2013 11:13 AM by Brandon Avants

# Customer Survey Data--4 fields and I want Red and Green

I have 4 different survey questions.  Timeliness, Friendly, Savings and Overall Sat.  I want each measure like Timeliness if above a 3 on a 1-5 scale to be green.  If it's below I want the square that reports the data to be red.  Any ideas how I would achieve this great feet of programing?  It's easy on one measure how do you do 4!  And now the gauntlet has been passed.

• ###### 1. Re: Customer Survey Data--4 fields and I want Red and Green

Hello Brandon,

I suggest you to read these two blog posts by Zen Master Steve Wexler

I'm sure those articles will shed some lights to solve your requirements and see a different perspective to visualize the result of your survey.

Best,

Ramon

• ###### 2. Re: Customer Survey Data--4 fields and I want Red and Green

I was looking to do something not so complex but that is very intersting.

I was looking to do something more like this Ramon.

• ###### 3. Re: Customer Survey Data--4 fields and I want Red and Green

HI Brandon,

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.

best,

ramon

• ###### 4. Re: Re: Customer Survey Data--4 fields and I want Red and Green

Ramon,

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%.