Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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