Cloud Quest #2: Consumer Purchase Aggregation

[Bren_Spill]

Spoiler

 

 

 

[The_Rad_Valentina]

So I learned that naming the columns is a bit finicky here. 

Spoiler

[Treyson]

Just a reminder! you need to attach something to your comment to get the credit for the badge.

[gawa]

I like UI of Cross-tab tool in Designer Cloud. 

Spoiler

By utilizing Count null and Count of Summarize tool, we can directly get Total... and Potential... columns without branching and join.

[OllieClarke]

As others have mentioned I think a 'select all' columns for cross-tabbing is essential. I also spent a *lot* of time waiting for data to load even having created new samples. This is especially annoying with blocking tools like the Cross-Tab coz you're just stuck with it.

[OllieClarke]

Gave up on my original workflow, made a new one and then everything worked beautifully.

Spoiler

[logdog0411]

Spoiler

 

[Diederik_vanderharst]

Voila, finding my way in A-cloud gradually.

Spoiler

 

[DaanVerkerk]

Without an append tool, mostly using logic. Only issue I ran into was getting 2 decimal point rounded correctly

Spoiler

[messi007]

My solution.

Spoiler