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 #197: Customer Density Reporting

Highlighted
13 - Pulsar

@AYXAcademy - TPS Report and Flair attached!

 

Spoiler
Workflow 197.png

 

Highlighted
Alteryx Certified Partner

Here is my solution !

Highlighted
Alteryx Certified Partner

My Solution here

 

Best Regards

Highlighted
6 - Meteoroid

Looking at the output files, it appears my numbers are ever so slightly off. Any idea why the math would be different from what I entered vs. the solution?

 

Spoiler
DavidStahl_0-1578511200105.png
Highlighted
8 - Asteroid

good practice about spacial functions, thanks

Highlighted
Alteryx Certified Partner

See the attached files for my answer.

Cheers.

Highlighted
Alteryx Certified Partner

My solution! Thanks

Spoiler
197.PNG
Highlighted
8 - Asteroid

Here is my solution - with a header page...

 

Spoiler
Here is the macro to produce the file.
pasccout_0-1578572912770.png
Highlighted
5 - Atom

Gave this one two goes as my first was seriously messy

Highlighted
12 - Quasar
12 - Quasar

Love spatial challenges!

 

Spoiler
I had difficulty with the table tool in the end until I converted the density to a string.  It kept wanting to truncate at six decimals.  Also my reports are temporary pdfs....not sure if I need to write them as 0-5 and 5-8.