Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

aheikes
8 - Asteroid
Spoiler
Challenge8.JPG
Ashley2
8 - Asteroid

Challenge 8 Complete!

My Solution;

Spoiler
Ashley2_0-1585057810342.png

 

varunvarma87
8 - Asteroid

Challenge 8 completed 

 

Spoiler
varunvarma87_0-1585199514537.png

 

jjlauman
6 - Meteoroid

Challenge Completed

SemihKumluk
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.

O_Mel
6 - Meteoroid

Please find below my solution for Challenge #8. 

MarielJinang14
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. 

Sylvana
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

 

kenhermosura
6 - Meteoroid

Solution as attached...

 

Spoiler
kenhermosura_0-1585837679189.png

 

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