Challenge #8: Aggregate Consumer Purchases

[FredNajjar]

Spoiler

[JohanRanschaert]

solution in attach

[jarrod]

This is one of those problems that as a beginner Python user, Alteryx is 100x faster/easier than Python. 

Spoiler

#SnakingMyWayThruChallenges

[Josef1]

 Maybe a bit unorthodox approach

[grazitti_sapna]

Hi, Please find my attached solution for the given Challenge

[mmmary17]

Spoiler

Am I the only one who loves the clean data tool for NULL values?

[KGS]

Hi,

To match the results, altered the results "since July" and not June

Major tools used are Filter, Join, Cross Tab, Summarize and Formula to arrive at the solution. 

This exercise helped me to learn flag concept in order to narrow the filter search.

Best,

G

[maureenfbrennan]

Posting my first weekly challenge solution!  Woot woot! 

[scooter5624]

I think I solved this correctly.  This taught me a lot about cross tab, parsing date fields to a month, and getting Alteryx to give me a ratio

[hieu_hoang]

This is my solution. Kinda different from others but it works. Thanks