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

Skrupczak
7 - Meteor

Here is what I came up with without looking at the solution/others' approaches. I did check the Alteryx posted solution after and while it was a little different, I was reassured that it used a similar number of steps/tools, as I was afraid I took a lengthy approach. I am still looking forward to looking through other user's solutions to see where I may be able to get more efficient

htrivedi123
8 - Asteroid

I took a slightly different approach and it seems I used less steps

Timi8
7 - Meteor

My solution

Spoiler
Timi8_0-1591981507550.png

 

The_Rad_Valentina
8 - Asteroid

I was a bit confused because the dates to filter by are different on the start file from what is expected in the result. It would be great to change the wording in the start file to "July 2013"

 

vradcha1_0-1591994186577.png

I decided to concatenate the types and use the contains formula to filter out the meal types. 

Arun_KV
8 - Asteroid

Here is my solution 

yash20010
6 - Meteoroid

Here is my solution.

mike_w
8 - Asteroid

my solution 

jiteshthegenius
7 - Meteor

SPOILER

ncrlelia
11 - Bolide

Challenge 8

Satyajitsa
6 - Meteoroid

My solution, it got easier as I progressed along

challenge8.png