ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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 #8: Aggregate Consumer Purchases

petgrap
8 - Asteroid
Spoiler
Challenge 8.JPG
mmongeon
8 - Asteroid

There is something flawed in this challenge, the wording was ambiguous.

Also, many of these tickets/orders would have potentially been eligible for multiple meal deals: 2 burgers, 1 pizza, 3 sides, 3 drinks, to me that should equal 3 potential meal deals.

But then how would we calculate the total number of meals...

 

Anyhow, here is my solution: 

 

Spoiler
workflow 8.JPG

 

 

GalynaSkamrova
7 - Meteor

My version:

Spoiler
2018-05-17_09h15_01.png
mickael_gest
8 - Asteroid

My solution.

ABarber
7 - Meteor

Good one!

mmongeon
8 - Asteroid

The file

Kdpalmer
8 - Asteroid

This could be cleaner/more efficient, but got the job done

JonM
8 - Asteroid

 

Spoiler
The forever hand transpose tool!
Ukashi
8 - Asteroid

Thank you for yet another fun challenge :) 

 

 

Spoiler
 

image.png

 

 

SGriggs
7 - Meteor

Thanks!