Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Data Tabulation - creating survey data tables

MartinMarine
5 - Atom
‎04-18-2016 06:20 AM

We need to develop data tables where we cross tabulate survey data to produce a table with % values and a table with N values.

 

See the attached Excel workbook where I have Pivoted the Data to illustrate the desired output and provided examples.

 

The challenge is in creating one table that combines different questions on the x and y axis.

 

 

I have used IBM SPSS Custom Tables in the past to deliver the required outputs - http://www-03.ibm.com/software/products/en/spss-custom-tables

Preview file
122 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
MartinMarine
5 - Atom
‎04-19-2016 12:12 AM

Solution offered by  Henriette Haigh | Client Services Representative Alteryx - attached.

Create Cross Tabs.yxzp
Reply
connect with mentors
designer new user guide
Labels
Top Solution Authors
View All