Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Converting qualitative survey data

alexxjames
5 - Atom

Is it possible to set up a workflow to automatically convert text survey responses (Strongly Disagree, Disagree, Neither Agree or Disagree, Agree, Strongly Agree) into numbers (1-5) to be able to then calculate response percentages and improvements?

4 REPLIES 4
grazitti_sapna
16 - Nebula

@alexxjames, you can use a formula tool to convert the ratings into a rating bucket from 1 to 5 and then calculate the percentage.

 

If you can provide a sample dataset we may help you to create a workflow.

 

Thanks!

Sapna Gupta
alexxjames
5 - Atom

Hi Sapna - thank you, that would be great to see how it is done.

 

So I would be looking at converting all responses to numbers where Strongly Disagree is 1 - and - Strongly Agree is 5

 

I would be looking at response % per question

 

And also the improvement from column D to column E to assess improved understanding

grazitti_sapna
16 - Nebula

@alexxjames, try this and let us know if this is what you are looking for?

grazitti_sapna_0-1660116616429.png

grazitti_sapna_1-1660116644263.png

 

I hope this helps!

 

Thanks!

Sapna Gupta
alexxjames
5 - Atom

Brilliant, thank you so much

Labels