Cloud Quest #2: Consumer Purchase Aggregation

[andrewgu]

Solved during the AU-Syd weekly challenge hour!

This one was surprisingly a tricky one, especially with restructuring/counting the data to account for meals.

[bradshaw]

There's an AU-Syd weekly challenge hour!?

[AkimasaKajitani]

My solution!

スポイラ

I saw this challenge as Weekly challenge #8.

[Ladarthure]

Satisfying to build using the new interface. Love the cross tab function to only show specific columns, it removes the pain of having to have a select just afterward!

スポイラ

 

[FlorianC]

スポイラ

Designer Cloud workflow

[alexnajm]

Just a heads up, ">=" is available if you convert your column to a Date!

スポイラ

[biancang]

A familiar looking challenge ... 😁

スポイラ

[teddim]

スポイラ

 

This is how I solved it. The rounding threw me off a bit, but I figured it out.

[nwaters]

Cloud Quest 2 solution offering

スポイラ

[RWvanLeeuwen]

Not sure why we have this [Other] category all of a sudden... It does not fit the criterium, does it?

Here's my take

スポイラ