community
cancel
Showing results for 
Search instead for 
Did you mean: 
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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #95: Draw 1000 Apples in Under 60 Seconds

Fireball

I was worried about this one, but it ended up to be pretty fun - just parsing and reporting! It took me a while to figure out how to match the colors.

 

Spoiler
Workflow:
challenge_95_workflow.PNG



Output:
challenge_95_output.PNG







Alteryx Certified Partner

Another challenge done, and this was one of the tougher ones.

 

I did not knew Alteryx could do that, and I guess it comes down to the hardware as well, since it took 1:06 on my machine to draw everything 😃

2019-05-20 11_50_23-.pngThe Runtime

Spoiler
It took me a while to figure out, how to draw the apples, but my biggest challenge was how to do the actual reporting.

I will bluntly admit, that I had to look at some of the other solutions in order to figure that part out.

So in the end my solution ended up looking like this

2019-05-16 17_00_56-Alteryx Designer x64 - challenge_95_solution_verakso.yxmd.pngThe Workflow



And the result like thischallenge_95_solution_verakso.jpgThe result

On my way to Lhotse Face

/Verakso

Pulsar
Pulsar
Spoiler
What a cool challenge! There was no start file, so I got to use the correct orientation for my workflow (vertical)!

2.PNG

Capture.PNG
Asteroid

My solution. Both the drawing of apples and heatmap.

 

Spoiler
challenge 95 solution Eleonora Nazander.JPG

OK - I *may* have pumped my fist in triumph when I finally got the apples to come out the right way.  This was a great challenge!

Spoiler
Challenge_95_main_wkflw_solution.pngThis is the main workflow

 Apple_Poly_Builder Macro.pngThis is the macro to create the spatial objects

Apple_Madness.pngThis is the beautiful result!

 

 

 

Asteroid

My output is not as nice looking as the template, but I'm proud of it. I didn't realize there was a json parse tool, so I ended up using a whole lot of regex to do that instead. I also didn't use the heat plot / predictive analytics tool, and instead used a grid tool to map the points to a count using some spatial processes, which I thought was pretty neat, albeit somewhat inefficient.

Alteryx Certified Partner
Spoiler
95. Spatial.PNG


What a difficult challenge! Used a lot of @LordNeilLord's solution to help me do this one.


Alteryx Certified Partner

First try was using R to load the ndjson file, but it was much easier to copy paste the file and change the extension to a .txt

I have the parts I need but juggling them around to arrive at the exact same solution as Joe M seems too much of a hassle. I really hope that one day reporting will be intuitive in Alteryx and will not result in broken workflows and shapes that even Tableau can no longer read.

 

Workflow:

Spoiler
95.png
Alteryx Partner

Never enjoy using the reporting tools. Initially I used only spatial tools, but then I remembered the reference to R so I went with that method in the end.

Spoiler
Challenge 95.pngworkflowChallenge 95 output.pngoutput
Highlighted
Spoiler
Challenge95.PNG

 

Challenge95-pdf.PNG