Challenge #8: Aggregate Consumer Purchases

[mihir_sampat]

It was a very challenging problem. The solution seemed so unintuitive because of the custom input to took me a while to find the solution.

Spoiler

[Annoushka]

The results of my solution are different because I assumed that the statement 'Pizza OR Burger along with a Side and Drink' means that there should be counted only 2 types of tickets including Pizza, Side and Drink (1) or Burger, Side and Drink (2), meaning that those tickets that include both pizza and burger should not be taken in consideration. Also, I thought that 'since June 2013' should include June, but to be closer to the results provided in output, I excluded this month in the filter. 

Anyway, thanks for the challenge, it was interesting!

[jsenk]

Solution

[Cndro_Consulting]

Spoiler

[VizChic]

@Annoushka - I really like how you've explained your solution, and why you've chosen a different answer 🙂

[dmhatchell]

Spoiler

[Dante_Healy]

A little tricky - I got confused with ticket count versus sales values. 😞   However, I'm glad I got to the answer in the end!  🙂 

[Marc_Schmitz]

Here is my solution

[DemandEngineer]

Please please please... update the text in the actual Designer files... this drove me crazy for a couple days.  Then I came back to the forum and realized the date should be changed (ignoring what's in the Alteryx file... 

[Per]

Another one down