Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #8: Aggregate Consumer Purchases

AidanBramel
8 - Asteroid

Attached are my solutions! My first attempt worked but was a bit clunky with 12 tools, so I started over and got it down to 7 tools. 

 

Spoiler
Challenge 8 Final solution.PNG
Lee_Gibbons
7 - Meteor

Solution Attached :D

Wouter
8 - Asteroid

My solution:

Spoiler
challenge 8.jpg
myastarling
10 - Fireball

My solution is attached.

kat
12 - Quasar
Spoiler
Challenge #8.PNG
AT_12
7 - Meteor

Summarize by Type > Get Count
Transpose to get count of Each type
Apply formula to identify Purchase

EFran
7 - Meteor
Spoiler
Sol.png
MattDuncan
7 - Meteor

Solution attached

Vinutha
8 - Asteroid

Crosstab and Summarize tools.

Inactive User
Not applicable

Bit of a long way round, but got there eventually!