survey data

Hello Alteryx community,

I am just getting started and I need to analyze a survey that my boss gave me. There are 100+ questions with answers of 1 through 4. I want to create a report that shows all questions and the percent of total value for each response.

Something like this............

1 2 3 4

1 25% 13% 17% 45%

2 30% 20% 20% 30%

...

survey example.xlsx

Best Practices

Accepted answers

JoshKushner

This solutions uses a healthy combo of tools. See if this works out for you:

Flow:

Results:

Select:

Formula:

Summarize:

Join:

survey data.yxzp

NickC

Hello Luke,

I worked this out by using transposing the data to get it into a vertical structure so I could then work out the percentages. Currently its hard coded to 19 but you could easily use a summarize and append to get the total number of respondents in a dynamic way.

See workflow attached for v11

% survey.yxmd

All comments

JoshKushner

This solutions uses a healthy combo of tools. See if this works out for you:

Flow:

Results:

Select:

Formula:

Summarize:

Join:

survey data.yxzp

NickC

Hello Luke,

See workflow attached for v11

% survey.yxmd

Luke_Barry

This was helpful. Thanks!

Luke_Barry

Wow! Thank you for the detailed response. I got through it with your help!

laquino

I am not able to open the attachment since it is in a more recent version of Alteryx than what I have through my company. I am also very new to Alteryx. Is it possible to provide screenshots or detailed descriptions of what needs to be done at each step from beginning to end?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703