We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
alteryx Community

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #357: College Majors in High Demand

Alteryx

A solution to last week's challenge can be found here.

To solve this week's challenge, use Designer Cloud or Designer Desktop.

This challenge comes to us from @randall_king

Haven't heard about Designer Cloud yet? Watch a demo.

In this weekly challenge, you need to clean and format data; sort data; and create a calculated field.

Your high school-aged child is planning on attending college after graduation. They do not know what they should choose as a major, so being the great parent you are, you want to steer them in the right direction.

Based on this dataset, determine which majors have an employment rate equal to or higher than 80%. If you suggest these areas of study to your child, you may have the best chance of making sure they don't move back into your house after college graduation!

For this challenge you should:

1. Split the data into columns on the comma delimiter.
2. Convert the first row of data into a header.
3. Assign appropriate data types to numeric columns.
4. Create a column that calculates the percent (rounded up to the nearest whole number) of students who are employed. Use the Employed and Total columns for your calculation.
5. Sort the data in descending order.
6. Filter the majors with an employment percentage equal to or higher than 80%.

Data Source: www.kaggle.com/datasets/tunguz/college-majors

9 - Comet
Spoiler

11 - Bolide
Spoiler

8 - Asteroid
Spoiler
Solution Attached

8 - Asteroid
Spoiler
Straightforward

Alteryx

Completed using Designer Cloud (Trifacta Experience)! Recipe included.

Spoiler

11 - Bolide

I missed the part of the direction that you round 'up'.   That cost a few min getting it to equal 35 results.

Spoiler

8 - Asteroid

Now the question is what percent of people are working in the specialized field of study? I'm definitely not.

Spoiler

8 - Asteroid
Spoiler

18 - Pollux
Spoiler