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
...
Solved! Go to 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
This was helpful. Thanks!
Wow! Thank you for the detailed response. I got through it with your help!
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?