survey data

[Luke_Barry]

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%

3

4

5

...

[JoshKushner · Accepted solution]

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

Flow:

Results:

Select:

Formula:

Summarize:

Join:

[NickC · Accepted solution]

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

[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?