Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASteps 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 %