alteryx Community

# Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## Challenge #364: Career-Minded Barbie

Alteryx

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

To solve this week’s challenge, use Designer Desktop, Designer Cloud, Designer Experience, or Designer Cloud, Trifacta Classic.

Over the years, Barbie, the doll made by Mattel, has had a lot of different jobs! She has been super busy. Did you know she ran for President of the United States 10 times? Quite impressive!

This dataset complies a list of Barbies that were released from 1959 through 2020. It includes the career name and type of career for that Barbie.

For this challenge, first determine which career Barbie had more than twice between the years 2017 and 2019.

Next, calculate by job type how many different types of jobs Barbie held over the years from 1959 through 2020, including the percentage of each.

12 - Quasar
Spoiler

14 - Magnetar

Nice and easy this week

Spoiler

8 - Asteroid
Spoiler
Alteryx, It's fantastic!

9 - Comet

My Solution

Spoiler

8 - Asteroid
Spoiler

16 - Nebula

Solution Attached.

Spoiler

Python Tool...

Spoiler

11 - Bolide
Spoiler

11 - Bolide

My Solution:

Spoiler

ACE Emeritus

Solution assumes the NULL years are between 1959 and 2020

Spoiler