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
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.

Challenge #107: Plot Employment Rates by Gender in the US

JoeM
Alteryx Community Team
Alteryx Community Team

In honor of the new roll-out of the Women of Analytics group,  we decided to theme this week's challenge!

 

This women's history month, let's analyze employment rates of men and women in the United states with data from the Bureau of Labor statistics. One of the challenges will be navigating the difficult excel file structure of merged headers, and the other will be reporting on the overall percent of men and women in the workforce. Try to replicate the chart pictured in the output.

report.png

For more advanced users, try to calculate the slope of the employment rate and around what year the slopes are set to intersect assuming linear growth. Plot the trend lines on the report chart as well!

 

jamielaird
13 - Pulsar

 

Spoiler

Here's my solution. Nice to play around with the charting tool, as I use it so infrequently. Had to resort to a slight hack to hide the horizontal axis labels.

challenge_107_JL.png

 

LordNeilLord
15 - Aurora

Wow @jamielaird that's got to be one of the quickest submissions ever!

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

 

 

jamielaird
13 - Pulsar

I’ve got my email notifications finely tuned 😉

David-Carnes
11 - Bolide

OK, six tools total.  I got a weird error trying to figure out the trends   and don't have time to work on it.

challenge 107 output.png

Spoiler
challenge 107.png
patrick_digan
16 - Nebula
16 - Nebula
Spoiler
Capture.PNG
bdaniels
8 - Asteroid

Intermittent Charting tool Error but aside from that, good first experience with the tool

 

Spoiler
Screen Shot 2018-03-12 at 12.21.55 PM.png
DanielArenas
7 - Meteor

was stuck with plot but i finally made it.... kinda

output.png

 

 

 

Spoiler
Captura.PNG

 

 

mmontgomery
6 - Meteoroid
Spoiler
Screenshot.PNG
MJG
7 - Meteor