# Weekly Challenge

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

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

Submit Feedback
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.

## Challenge #8: Aggregate Consumer Purchases

Highlighted
8 - Asteroid
Spoiler
Highlighted
8 - Asteroid

Challenge 8 Complete!

My Solution;

Spoiler

Highlighted
8 - Asteroid

Challenge 8 completed

Spoiler

Highlighted
6 - Meteoroid

Challenge Completed

Highlighted
7 - Meteor

Very clever way of filtering by summing the cell values.

I was trying to sum row tickets if they comply with the criteria. Is there a way to check if the cell is not empty? Isnumber() multiplied the other cell with -1.

Highlighted
6 - Meteoroid

Please find below my solution for Challenge #8.

Highlighted
7 - Meteor
Spoiler

Didn't know the filter used in the solution so I used 3 filters instead. Now I know how I can filter easily with this kind of data. Thanks!

My answer was wrong at first since I put salad and soup as sides too. hehe.

Highlighted
8 - Asteroid

Here is my solution.

Spoiler
I solved it with filters and joins and sticked to the hints for the date: >2013-06-30 to get the right figures.

Highlighted
6 - Meteoroid

Solution as attached...

Spoiler

Highlighted
8 - Asteroid

Finally got it right. Good practice for sum function. I have learnt to use 1 and 0 by going through some of previous solution.

Spoiler

It was wierd that the same formula did not work in the first go. After I restart Alteryx, it worked.

Contains([Concat_Type], "Drink") && Contains([Concat_Type], "Side") &&
(
Contains([Concat_Type], "Burger") ||
Contains([Concat_Type], "Pizza")
)