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 #196: Determine Profit Margin

Highlighted
11 - Bolide
Spoiler
 
Highlighted
5 - Atom

Using "Tile" tool 

Highlighted
8 - Asteroid

Solved!

Highlighted
7 - Meteor

My solution

Highlighted
11 - Bolide
Spoiler
PaulFound_0-1594793761889.png

 

Highlighted
12 - Quasar

my solution

Highlighted
Alteryx Partner

NIce, quick challenge. Thanks for the formulas!

 

Spoiler
Capture.PNG
Highlighted
8 - Asteroid

Solved

Highlighted
Alteryx Partner

Here is my solution to Challenge #196

 

Spoiler
grazitti_sapna_1-1598863144199.png

 

Thanks.

Highlighted
Alteryx
Alteryx

A bit rusty after not doing challenges for a while.

 

This one was tricker than it looked!

 

Spoiler
James Marks Week 196 Image.PNG
Spoiler
The trick for me was realising that you need to calcumate Sum_Cost and Sum_Revenue first before then working out a Quarterly Profit Margin. Previously tried doing it all in one tool and then calculating an average Quarterly Profit Margin but this does not give the true average!