Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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 #196: Determine Profit Margin

nitinsnow
Alteryx Alumni (Retired)
Spoiler
Spoilernitinsnow_0-1578303546658.png
OllieClarke
16 - Nebula
16 - Nebula

Catching up now 🙂

Spoiler
Challenge 196.png
JamesBills
8 - Asteroid

Solved my first weekly challenge

 

Spoiler
Spoiler

Solution Final.jpg

 

DanJ3
8 - Asteroid
Spoiler
Spoiler

196_sol_DanJ3.PNG

 

huynv96
9 - Comet

 

Spoiler
196.PNG

My solution! Good challenge!

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Rounded given output to ensure my answer matched to 6 decimal places.

Capture.PNG

msouriques
6 - Meteoroid

First Challenged solved!

 

Spoiler
msouriques_0-1578323051041.png

 

DanielMS
Alteryx Alumni (Retired)
Spoiler
Capture.PNG
Jess2
6 - Meteoroid

Here is my solution.

NicoleJohnson
ACE Emeritus
ACE Emeritus

My solution!

 

Spoiler
The key to this one was creating the quarterly groupings using Generate Rows tool + a pair of Multi-Row Formula tools. Someday I'll get around to creating a macro for the "pair of Multi-Row Formula tools" combo - I use this combination quite often when I need a bit more control over the outcome than the Tile tool provides.

WeeklyChallenge196.JPG

Cheers!

NJ