community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #63: Data Preperation Using Pivot Tools

Alteryx Certified Partner

My solution ..

 

Spoiler
challenge 63.PNG
Highlighted
Asteroid

My solution:

Asteroid

similar to provided solution

Asteroid

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
Alteryx Partner

Check out my solution.

 

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

 

Asteroid

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

Here's my solution to challenge 63.

Asteroid

Solution attached.

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

My solution.

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.