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

jridleh
7 - Meteor
Spoiler
SPOILERChallenge8.PNG

Done!

EdwinYakop
7 - Meteor

Pretty Interesting Exercise.. Catch will be the understanding with "since June 2003"

PhongVo
7 - Meteor

Just finished my first Weekly Challenge. Perhaps, need more clarification with 2 points in the question

  1. Meal Deals contain Pizza AND/OR Burger
  2. Since June: not including June (starting 01.07.2013)

Your Feedback will enlighten my day 😉

PhongVo
7 - Meteor

Starting date should be in the description

Tomas_Kozlik
6 - Meteoroid

Bad description in your workflow so I was getting wrong numbers all the time, but my solution works and I think I've done it the easy way.

mat_budden
8 - Asteroid

Hi All,

 

Please find my Results Below.

 

Spoiler
Filtered the Date, Join the Reference Table, Cross Tab, Cleanse , 2 Formulas, One to work out how many combos would be possible by pairs of Side and Drink then the next is if combos possible is greater than 1 and i have a pizza or a burger I am a combo. Then Summarize and work out the percentage.

Thanks

Mat

jlangl11
7 - Meteor
Spoiler
Workflow.PNG
RoDO
8 - Asteroid

My creative solution

 

Spoiler
challenge_8_RODO_Solution.png
myouree
8 - Asteroid

My solution

ZenonH
8 - Asteroid

I found that using Soup OR Salad to replicate Count_Side did not work the same as Count_Side. 

Spoiler
ZHSOL.png