We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #8: Aggregate Consumer Purchases

6 - Meteoroid

My solution

8 - Asteroid

I enjoyed this challenge since working with Retail Data is part of my normal activities.

11 - Bolide

My Solution!

8 - Asteroid

Here is my solution!

6 - Meteoroid

I definitely had a different solution than the posted one, but all works the same.

6 - Meteoroid

Good challenge, took me too long though!

8 - Asteroid

Here's my solution. Tricky but very easy if you are familiar with the Formula Tool and Summarize Tool

8 - Asteroid

3rd challenge complete. 


Initially used a join to combine the Point of Sale and Lookup Table before adding a filter to exclude dates recording transactions before 01/07/2013. Then used the summarize tool to sum the total transactions from the 1st of July. Cross tab was then used to group the transactions by TicketID and to display what each ticket entailed. Data cleansing used to turn the [Null] records into being displayed as 0's. Then used the formula tool to write a basic equation to calculate the number of deals before using summarize to total the number of potential deals. Final step was to use a formula to calculate the percentage of transactions that are potential deals.

Work flow.PNGResults.PNG
7 - Meteor


8 - Asteroid

Here is the solution with the Browse icons removed. Used string functions and boolean logic to simplify the problem.