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

Highlighted
Meteoroid

Done! Pretty fun.

Btw, that was my first experience using Spatial Objects.

Highlighted
Alteryx Certified Partner

Nice challenge albeit an easy one

Spoiler
197.jpg
Highlighted
Meteoroid

It was pretty intresting, this was my first practical experience with spatial objects and it is a interesting subject, looking forward to new challanges!

 
 
Highlighted
Alteryx Partner

simple tabular report for me

Spoiler
Challenge 197.png
Highlighted
Asteroid

Transformed number into text to be able to visualize as sample with many digits.

 

Spoiler
2020-01-06_11-41-11.jpg
Highlighted
Alteryx
Alteryx
Spoiler
Learning from this challenge is to leave your calculation (customer density) as a string in order to match the decimal places indicated in the report specification. Creating it as a double results in a 6-decimal place maximum in the table tool and converting the double to a 15 decimal place string results in a trailing zero on the Home Office Radius 0-5 Customer Density. 
Highlighted
Spoiler
Cover SheetCover SheetWorkflowWorkflowDataData
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution

 

Spoiler
06-01-_2020_20-21-16.png
Highlighted
Asteroid
Spoiler
197 COMPLETE.png

f463b39ea33256cd7f606405d4d81ca2769429e06e2e5df4b46a8031c517862c.jpg
Highlighted
Alteryx Certified Partner

This was fun, and right in my wheelhouse! 

Spoiler
JustinBabbittEAG_0-1578340254153.png