Challenge #8: Aggregate Consumer Purchases

[Shama18]

I am getting error in input file 

[Yoshiro_Fujimori]

It took some time to find the reason why the output did not match.

Objective on webpage:
In order to decide if we should start including a new "Meal Deal" on our menu we want to study the potential impact on recent transactions. Please identify the number and percentage of orders since July 1, 2013 which include the following categories of food: Pizza OR Burger along with a Side and Drink.

Objective on workflow comment:
We are thinking of including a new "Meal Deal" on our menu and want to study the potential impact on recent transactions. Identify the number and percentage of tickets since June 2013 which include the following categories of food: Pizza OR Burger along with a Side and Drink.

Using the date on webpage, the output matched.

My solution:

Spoiler

Workflow


Formula in Filter Tool
  (!IsNull([Pizza]) OR !IsNull([Burger])) AND
  (!IsNull([Side]) AND !IsNull([Drink]))

[tdiipo]

reattaching the exported workflow rather than the saved file...

Spoiler

[LimsKragma]

My solution

[anabelvelazque]

Hi! Here is my take :-)  

[kmbassett01]

Was a little confused on "Since June 2013" - had to change my workflow to exclude June 2013 instead of including it to get the right numbers.

[JacqueDavies]

Solution to complete onboarding module and receive badge :)

[Watermark]

Spoiler

Spoiler

 

[Watermark]

Spoiler

 

[JRBeaudry]

Nice one, this give me hard time on a technicality ... I had to look at the solution, because I couldn't find my mistake ... Is not the same date in the flow than on the website ...

Spoiler

But otherwise very good challenge!