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 #201: Wage Ain't Nothin' but a Number

Alteryx

This challenges focuses on charting the changes in the minimum wage over time since 1968.

For those not familiar, the minimum wage is the lowest hourly wage allowed by law. In the United States, there is a federally mandated minimum, but each state is allowed to enforce their own minimums. Below, you will find a file containing minimum wage data from 1968 - 2017 by state. The Text Input tool classifies each state into a region.

Use the inputs to create a()n (interactive) chart showing each region's average minimum wage by year.

Source: GIPHY

12 - Quasar

Go Chiefs!

Not quite sure how to check this against the result we were given to make sure everything is correct....

Spoiler
11 - Bolide
Spoiler

Fun practice with the interactive chart tool.

Alteryx Alumni (Retired)

Here's my solution

Spoiler
The actual challenge was relatively easy. The time consuming part was figuring out exactly how the averages were calculated. I started out assuming that NA was converted to null (which appears to be correct) and that the average of high and low was used (apparently wrong - it looks like the average was taken on the high value only). Following up on @RolandSchubert's comment, it would make more sense if 0 and NA values were replaced with the Federal Rate.
8 - Asteroid

First time using interactive charts. Nice tool 🙂

Spoiler
Wasn't so easy to find out which average is taken for the graph. I used the average of "High".
16 - Nebula

My solution.

Spoiler
The problem was to find out how averages were calculated. Once you realize that only [High.Value] is used and missing values are not replaced by Federal rates, it's quite simple.
11 - Bolide

Hi! Here my solution 🙂

ACE Emeritus

I guess the purpose of this exercise wasn't to get the exact output, but to get us playing with the interactive charting tool, in which case mission accomplished, and definitely better from the last time I used it!

10 - Fireball

17 - Castor
Spoiler