Challenge #8: Aggregate Consumer Purchases

[ferg_smith]

Spoiler

[alacoume]

My solution

[Victor_Hugo]

solución

[rcollins1986]

Not the cleanest but here is my solution

[kristiadiuisan]

Spoiler

[huyenntran97]

My solution for challenge 8:

[Kusk]

Challenge completed.  

[anay_zinje]

Amazing Challenge #8 Solved

Used Join, Filter, Criss Tab tool and formula tool to solve this problem. 

[viniciusahanada]

Steps and tools I used:

1. Find/Replace tool to replace food items names for their high-level description;

2. Convert [Date] data type from V_String to Date;

3. Filter Tickets with date >= "2013-07-01" - this was especially tricky - I need to work on my English skills;

4. Cross Tab, grouping by "TicketID', changing "Desc" headers with "TicketID" values and "First" method;

*** Here my workflow separated ***

Path A

5a. Filter using formula "(!IsEmpty([Burger]) OR !IsEmpty([Pizza])) AND !IsEmpty([Side]) and !IsEmpty([Drink])"

6a. Summarize tool, counting by "TicketID";

Path B

5b. Count Records tool

*** Workflow got back together ***

7. Append Fields tool - join both number of records (potential meal deals and total tickets)

8. Formula Tool to calculate %

[psk009]

#8 Solution: Tools used - DateTime , Filter , Join, Summarize, Formula, Cross Tab, Append