2 Replies Latest reply on Oct 26, 2017 2:51 PM by Diogo Braga

# Add '1' in front of questions with over 10% of Disagree and Strongly Disagree

I have a list of survey questions, and I want to put a 1 in front of the ones that have over 10% of Disagree + Strongly Disagree responses.

Refer to Sheet 37 and 38 of the workbook.

So far, I have this calcs:

Disagree + Strongly Disagree  = SUM(IF [Response] = "Strongly Disagree" OR [Response] = "Disagree" then [Value] END) / SUM([Value])

if [Disagree + Strongly Disagree]>.1 then COUNTD([Question]) else 0 end

This shows the number of questions in each category with over 10% of Disagree + Strongly Disagree responses.

The '1' will be added as a new column where you see the red arrow in the screenshot below:

• ###### 1. Re: Add '1' in front of questions with over 10% of Disagree and Strongly Disagree

Diogo,

The only thing missing is to bring Calculation2  as a discrete value at the left of Metric(group).

In the example (Sheet 40) , I modified Calculation2 to return an empty string instead of a 0, I was not sure if you want to display only the 1s.

Michel

• ###### 2. Re: Add '1' in front of questions with over 10% of Disagree and Strongly Disagree

This solution duplicates the questions and separates the results. The correct solution will add the number '1' or '0' in front of EACH question WITHOUT duplication or separation.