Challenge #201: Wage Ain't Nothin' but a Number

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.

dollar dollar bills.gif

Source: GIPHY

Challenge_201_start_file.yxzp

Challenge_201_solution.yxzp

Reporting

Join

Preparation

Advanced

Data Analysis

Intermediate

Accepted answers

All comments

Blake

Go Chiefs!

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

Spoiler

Challenge_201_start_file_BH.yxzp

Aaron_Harter

Spoiler

Fun practice with the interactive chart tool.

WC 201 - AB Data Consulting_Aaron.yxzp

TonyA

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.

Challenge_201_TA.yxzp

Sylvana

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

Challenge_201_start_file_Sylvana.yxzp

RolandSchubert

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.

Challenge_201_solution_rsc.yxzp

RichoBsJ

Hi! Here my solution 🙂

Challenge_201_richobsj.yxzp

BenMoss

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!

Challenge_201_bm.yxzp

rmassambane

Challenge_201.yxmd

patrick_digan

Spoiler

Challenge_201_start_file.yxzp

Greg_Murray

solution attached.

Challenge_201_solution GM.yxzp

JohnJPS

Nice practice with the Interactive Chart, which I, hanging head in shame, had never used before.

Spoiler

c201_jps.yxmd

JennyMartin

Spoiler

Check out my video solution here: https://www.dataprepsolutions.com/2020/02/alteryx-weekly-challenge-201.html

AWC201.yxzp

JReid

Good concept, but I think I would push for more background information and a cleaner data set before making any type of decision based on these graphs. I also think that it would be more applicable to see the effective rate per region (the greater of Federal or Local).

Spoiler

Challenge_201_start_file.yxmd

JoshuaGostick

My solution 🙂

Spoiler

challenge_201_JG.yxzp

OllieClarke

It took me longer than I'd like to remember/work out how to colour the lines 😞

Spoiler

Output

workflow

challenge_201_OC_solution.yxzp

T_Willins

My workflow. I like the challenges that keep you sharp on reporting tools.

Spoiler

Challenge_201_solution.yxmd

hbraunius

My solution attached.

challenge_201_solution_hb.yxzp

reply_mueller

Hey there,

this is my first challenge, so I hope there are no rules that I violated.

Spoiler

Have a nice day!

Best,

Johannes

challenge_201-mueller_johannes.yxzp

jmt214

Took a little bit of investigation and frustration to realize that I had to transpose the data to add the individual layers because I work on an old version of Alteryx (2018.3) that doesn't have the layer split functionality yet.

Spoiler

Challenge_201_start_file_solved.yxzp

ZenonH

Still working on #200 because I don't want to submit until I solve the whole thing. Took me a little bit to understand how to group by region in the reporting tool, but other than that pretty straight forward (:

Spoiler

Challenge_201_ZHSOL.yxzp

TheWizLo

Spoiler

Challenge_201_start_file.yxmd

ggruccio

Great practice with this tool!

Spoiler

Challenge_201_gg_finish.yxzp

Strohy

Solution attached. Thanks

Spoiler

Challenge_201_my_soln.yxmd

nivi_s

Solved! Wasn't too sure of how the averages/null values were treated, so I made some assumptions. And just for fun, I wrote a quick standard macro that cleans up the text from the Chart Output.yxdb file to compare my solution with the data in the chart shown in the output!

Spoiler

Challenge_201_solved_NS.yxzp

kelvin_law1

Here is the solution with the chart output:

Spoiler

Challenge_201_solution.yxzp

saravanasriram

Great opportunity to learn more about visualisation and charts..

Spoiler

Challenge_201_start_file.yxmd

JamesCameron

My Effort - Running 11.7, so no interactive chart

Spoiler

challenge_201_solution.yxmd

danilang

Spoiler

Like several people have mentioned the challenge here was determining which measure was charted. After tha the graph was straighforward

Challenge_201_solution_dl.yxzp

Ryan_K

Spoiler

Challenge_201_start_file_RK.yxmd

davewarren

An assortment of insights... 🙂

Spoiler

Challenge_201_DW.yxzp

seinchyiwoo

Spoiler

Challenge_201_solution_file_sc.yxzp

Ladarthure

FUn one, never had the opportunity to use the tool before!

Challenge_201_start_file.yxmd

gayathri27

Hi ! I am trying to create the interactive chart but not sure how to proceed further on creating the chart. The requirement is to show each region and its average wage per year.. do i create multiple charts?
Use the inputs to create an interactive chart showing each region's average minimum wage by year.

aaziz2

So do I, have tried different configuration, still have not gotten the same chart

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703