Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #197: Customer Density Reporting

Quasar

@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
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
Asteroid

good practice about spacial functions, thanks

Highlighted
Alteryx Partner

See the attached files for my answer.

Cheers.

Highlighted
Asteroid

My solution! Thanks

Spoiler
197.PNG
Highlighted
Asteroid

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

 

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

Gave this one two goes as my first was seriously messy

Highlighted
Bolide
Bolide

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.