Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

sonyakasenkramer
8 - Asteroid
Spoiler
sonyakasenkramer_0-1577821538645.png
baibhav95
5 - Atom

Got to learn a bit about the summarize tool on this one. Nice

SueDonim
8 - Asteroid

Not difficult but ended up being a little more involved than I expected.

 

Spoiler
Process:
- Separate data to columns
- Clean-up and set data types
- Convert to proper date format
- Clean-up and Sort by Client ID and Date
- Determine Quarter for each client
- Extract Year from date
- Join with Cost data (join on Year)
- Calculate cost and revenue for each client and quarter
- Aggregate Revenue and Cost (group by quarter)
- Calculate profit margin
- Sort (desc)

MySolution.PNG
jacrae
7 - Meteor

Nice one!

Spoiler
Capture.PNG
RobertW
Alteryx
Alteryx

Not too bad...

Spoiler
RobertW_0-1577739806403.png
TylerNa
10 - Fireball

An interesting take on quarters.

Spoiler
WC 196 Quarters.png
dho111
7 - Meteor
Spoiler
196_spoiler.JPG

2019 last challenge!!

BradWerner
11 - Bolide

Thanks for the challenge @Treyson!

Spoiler
196 complete.png
JamesCameron
8 - Asteroid

Here is my solution

 

Spoiler
JamesCameron_0-1577777764929.png
jv1
8 - Asteroid
Spoiler
jv1_0-1577782876176.png