We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #373: Fish and Chips, Anyone?

rbrown
6 - Meteoroid

This instruction/hint doesn't make sense to me:   If you come across a record that combines 2 years into a single record, for example 201516 or 2021-22, divide the value equally and generate a record for each year.

 

If they are averages, how does dividing them in half help?  I was able to get the same answer as the solution by doing that, but it didn't make a lot of sense - an average over 2 years is not the same as 2x one year's average.  Am I missing something?

 

rbrown
6 - Meteoroid

agreed, this didn't make sense to me either

rbrown
6 - Meteoroid

same...confused by those instructions

TurboToad
11 - Bolide

My Solution.

 

Spoiler
TurboToad_0-1685474280961.png

 

Tgigs
8 - Asteroid

Here is my solution.

ARussell34
8 - Asteroid

Now I'm hungry!

alexnajm
18 - Pollux
18 - Pollux

Very weird challenge

braveraj
11 - Bolide
Spoiler
braveraj_0-1685486733353.pngbraveraj_1-1685486761488.png

 

 

acarter881
12 - Quasar

Here's my solution. The directions about the value splitting are unclear to me. However, I was able to get the same output as the sample.

Spoiler
acarter881_0-1685494890079.png
Watermark
12 - Quasar
12 - Quasar

Like everyone else, without values to compare, you're left to just decide your result with directions that leave room for interpretation.  

 

I'm fairly confident in my approach, but it left me with a different year for fish.  Not a fan of the directions or the provided answer without values to validate.

 

 

Spoiler
MT_Solution_373.jpg