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
Challenge8.JPG
Highlighted
8 - Asteroid

Challenge 8 Complete!

My Solution;

Spoiler
Ashley2_0-1585057810342.png

 

Highlighted
8 - Asteroid

Challenge 8 completed 

 

Spoiler
varunvarma87_0-1585199514537.png

 

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
Challenge #8.PNG

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.

Sylvana_0-1585749305758.png

 

Highlighted
6 - Meteoroid

Solution as attached...

 

Spoiler
kenhermosura_0-1585837679189.png

 

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
steven4320555_1-1585849463591.png

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")
)