Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #63: Data Preperation Using Pivot Tools

Highlighted
Alteryx Certified Partner

My solution ..

 

Spoiler
challenge 63.PNG
Highlighted
Alteryx Partner

My solution:

Highlighted
8 - Asteroid

similar to provided solution

Highlighted
12 - Quasar
12 - Quasar

A lengthy solution to work through this one. I definitely look forward to seeing other solutions to see if there is any simpler solutions.

Spoiler
Challenge 63.PNG
Highlighted
Alteryx Partner

Check out my solution.

 

I am pretty confident no one did it in that way before me :)

 

Highlighted
8 - Asteroid

Mine is not a pretty or concise solution but seems to work...

Highlighted
Alteryx Partner

Here's my solution to challenge 63.

Highlighted
8 - Asteroid

Solution attached.

Spoiler
22-03-2019 16-36-56.png
Highlighted
7 - Meteor

My solution.

Highlighted
5 - Atom

Attached my Solution. I added a formula to calculate the total point of sales if missing. Additional Idea: could be extended to validate the data.