Challenge #8: Aggregate Consumer Purchases

[aheikes]

Spoiler

[Ashley2]

Challenge 8 Complete!

My Solution;

Spoiler

[varunvarma87]

Challenge 8 completed 

Spoiler

[jjlauman]

Challenge Completed

[SemihKumluk]

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]

Please find below my solution for Challenge #8. 

[MarielJinang14]

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. 

[Sylvana]

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.

[kenhermosura]

Solution as attached...

Spoiler

[steven4320555]

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