Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #197: Customer Density Reporting

avilagon
7 - Meteor

Done! Pretty fun.

Btw, that was my first experience using Spatial Objects.

RWvanLeeuwen
11 - Bolide

Nice challenge albeit an easy one

Spoiler
197.jpg
JoseAlcorta
6 - 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!

 
 
OllieClarke
15 - Aurora
15 - Aurora

simple tabular report for me

Spoiler
Challenge 197.png
JORGE4900
8 - Asteroid

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

 

Spoiler
2020-01-06_11-41-11.jpg
mheinze
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. 
patrick_digan
17 - Castor
17 - Castor
Spoiler
Cover SheetCover SheetWorkflowWorkflowDataData
RolandSchubert
16 - Nebula
16 - Nebula

My solution

 

Spoiler
06-01-_2020_20-21-16.png
BradWerner
11 - Bolide
Spoiler
197 COMPLETE.png

f463b39ea33256cd7f606405d4d81ca2769429e06e2e5df4b46a8031c517862c.jpg
JustinBabbitt
Alteryx
Alteryx

This was fun, and right in my wheelhouse! 

Spoiler
JustinBabbittEAG_0-1578340254153.png
Justin Babbitt