Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #381: Average Monthly Sales with a Twist

TH
8 - Asteroid

I found this one disappointing, honestly.

Initially I was excited that I'd be able to use some new and different tools.

Started by trying to write it in Python, but weirdly I couldn't get the Python tool to read the input file.

I tried playing around with multi-field formula and dynamic select, but neither of those really worked for this problem.

In the end I needed just the FORMULA tool to get the right answer.

The SELECT tool that I added just makes the output look pretty.

Qiu
21 - Polaris
21 - Polaris

Completed.

Spoiler
Challenge_381.PNG
Ray_Pospisil
8 - Asteroid

Alteryx and SQL solution attached

Marcel_E
6 - Meteoroid
Spoiler
2023-08-02 15_10_11-Alteryx Designer x64 - Challenge 381_me.yxmd.png

olivier_newman
8 - Asteroid

took a while 

gerda
8 - Asteroid
Spoiler
Screenshot 2023-08-03 101822.png

Here's the solution!

cgetz23
7 - Meteor

Complete!

Carolyn
12 - Quasar
12 - Quasar

Complete!

Spoiler
2023-08-03 13_46_12-Alteryx Designer x64 - Challenge 381_start file.yxmd.png

martinding
13 - Pulsar
Spoiler
381.PNG
Reesetrain2
9 - Comet
9 - Comet

My solution,

Spoiler
Screenshot 2023-08-04 221805.png