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
10 - Fireball

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

My solution,

Spoiler
Screenshot 2023-08-04 221805.png