Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
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 #201: Wage Ain't Nothin' but a Number

Highlighted
8 - Asteroid
Spoiler
2020-02-08 14_03_40-Greenshot.png2020-02-08 13_59_37-Greenshot.png

 

Highlighted
7 - Meteor
Spoiler
Spoiler
Highlighted
7 - Meteor
Spoiler
Spoiler
Highlighted
5 - Atom

Challenge accepted!

 

Capture.JPG

 

Highlighted
6 - Meteoroid
 
Highlighted
Alteryx Partner

Nice quick one, but good to work on graphing skills as I move away from Excel....

 

Good points from @ChristinaFPE (on "Split" under "Transforms") and from

(on "Offset" and "Stepsize" under "Spacing").  I hadn't noticed either of those before.  Likes for both of you.

Spoiler

Process
- Join tables on field "State"
- Convert field "high.value" to number
- If "Region" is null, then rename as "Federal"
- GroupBy "Region" and "Year" and take average of "high.value"
- Cross-tab so that Year is in rows and Region in columns
- Create line chart with each region as its own layer
- Render so can display (below) full chart

Chart.PNGMySolution'.PNG

 

 

Highlighted
5 - Atom

Good One !!!..had never used interactive tool before...

Highlighted
Alteryx Partner

Here is my solution !

Highlighted
8 - Asteroid

Wasn't sure if we should take the average of the federal rate for the states where rate was 0, but here is my solution

Highlighted
Alteryx
Alteryx

Took some work to figure out which data to use.  Almost went and parsed it myself, but I didn't.

 

Spoiler
RobertW_0-1581377680978.png