Survey Responses by Manager

Question

Hi everyone,

I'm relatively new to Alteryx and I am working on a dataset that has multiple survey responses per manager for use in PowerBI. I need to do the following things:

* Replace the survey response values to either postive or negative only (I believe I can do this with find and replace?)
* Calculate the % of each answer for each question by manager

Manager #

Q1

Q2

231

Agree

Disagree

460

Agree

Strongly Disagree

732

Strongly Agree

Agree

231

Disagree

231

Agree

Strongly Agree

460

Strongly Agree

Agree

Thank you in advance!

CQuinn · Answer

This does help, thank you!

TheMattLeonard · Answer

You can definitely accomplish the positive/negative question with find and replace, though I prefer to use the Join tool in most cases like this.

You'll first need to create a mapping file, which you can do in Excel or with a Text Input Tool in Alteryx. You just need two columns where one column is every possible answer (4 by my count) and the other column is whether it's positive or negative.

Before joining this to your data set, you'll need to transpose it. Attach a transpose tool to your Manager answers and select Manager # as your key column, and all the questions as your Data Columns.

You can then use a Join tool to go between your manager answers and your positive/negative mapping.

I'll be honest, I'm a little unclear on what you mean on Item 2, but I imagine a Summarize Tool will come next in accomplishing what you need to.

Hope this helps!