Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Summarizing survey results

JessicaN
5 - Atom

We use an exit survey system for employees who leave our organization. The data comes from the vendor and there's no flexibility in the format. I'm trying to summarize the results, but running into issue because there are some merged fields for the question numbers and names. 

 

I've attached a sample of what I receive from the vendor. The first two questions are showing if an employee selected one of the options as an answer to the question. Where a '1' is listed that indicates they selected a value. If not value, then they did not select it.

 

For the third question, each option is in ranked on a scale from 1-4. There are 4 values that can receive a ranking within the one question. 

 

I'd like to summarize these results to show the following:

Question 1 - how many people selected benefits as what they liked?

Question 1 - how many people selected salary as what they liked?

Question 1 - how many people selected communication as what they liked?

Question 1 - how many people selected co-workers as what they liked?  

 

Question 2 - how many people selected benefits as what they didn't like?

Question 2 - how many people selected salary as what they didn't like?

Question 2 - how many people selected communication as what they didn't like?

Question 2 - how many people selected co-workers as what they didn't like? 

 

Question 3 - what was the average rating for clear career path?

Question 3 - what was the average rating for respect in supervisor?

Question 3 - what was the average rating for work life balance?

Question 3 - what was the average rating for benefit options? 

 

Any advice would be appreciated! 

3 REPLIES 3
Thableaus
17 - Castor
17 - Castor

Hi @JessicaN 

 

Here's the solution I'm providing you.

 

Solution.PNG

 

Notes to take:

- Replace the Input with your original Excel File Path

- Notice that I marked the option to Start Data Import on Line 3

- I also did a Reference Table with Text Input and used a Find and Replace Tool to replace the columns with your questions.

 

Workflow solution is appended.

 

Let me know if you have any doubts.


Cheers,

fatihsub
6 - Meteoroid

Sounds like the problem is skipping the first two rows. 

 

Then you can solve this using by only input tool. In the options, select Start Data Import on Line as 3.

 

1.png

 

Then you can also consider using transpose tool to compare the values easily.

JessicaN
5 - Atom

This works perfectly! The biggest issue was that I wasn't able to tie the responses back to the associated question. I've never used the Tile tool before. Thanks so much for the quick response!

Labels