Summarizing survey results

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!

Sample ExitSurvey.xlsx

Workflow

Help

Preparation

Accepted answers

Thableaus

Hi @JessicaN

Here's the solution I'm providing you.

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,

Solution.yxmd

All comments

Thableaus

Hi @JessicaN

Here's the solution I'm providing you.

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,

Solution.yxmd

fatihsub

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.

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

JessicaN

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!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335