Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

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

Director, Customer Enablement
Director, Customer Enablement

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.


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!


Alteryx Certified Partner



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.



Alteryx Certified Partner

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



Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover



Alteryx Certified Partner

I’ve got my email notifications finely tuned ;-)

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

challenge 107.png

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


Screen Shot 2018-03-12 at 12.21.55 PM.png
Alteryx Certified Partner

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








Alteryx Partner