Challenge #8: Aggregate Consumer Purchases

[Mausam]

My solution. Really simple. 

Spoiler

[atrozz]

Hello. Nice exercise!!!

Spoiler

First, join by Desc. I convert date, string to date and filter by 2013-07-01. Group by ticketid, type and count of Price; cross tab by type and values is count Price. Replace nulls with zero and apply a formula to DealCount. Next, count all ticketid and sum of DealCount and again i apply a formula: ([dealCount]/[Total]) *100 and i get the result.

[Abell]

The date part threw me off (wording could be a bit more clear) but once I re-interpreted the challenge I figured it out!

[nilaysameer]

My version of solving it. Klutzy but worked.

[hfanda73]

the objective is not too clear but luckily the sample outcome is provided. I have created the filter based on what is stated in the objective date (which is different to the sample result). It's kind of harder than Beginner level i think, but here is my solution.

[jdemeaux]

here we go!

[Steph_Maddrell]

My solution attached

[ryantsullivan]

My solution is attached.