Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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

T_Willins
14 - Magnetar
14 - Magnetar

@AYXAcademy - TPS Report and Flair attached!

 

スポイラ
Workflow 197.png

 

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

carlosteixeira
15 - Aurora
15 - Aurora

My Solution here

 

Best Regards

Carlos A Teixeira
DavidStahl
メテオロイド

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?

 

スポイラ
DavidStahl_0-1578511200105.png
nini
アステロイド

good practice about spacial functions, thanks

delilah
アステロイド

See the attached files for my answer.

Cheers.

huynv96
コメット

My solution! Thanks

スポイラ
197.PNG
pasccout
アステロイド

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

 

スポイラ
Here is the macro to produce the file.
pasccout_0-1578572912770.png
JonDewhurst
メテオロイド

Gave this one two goes as my first was seriously messy

ggruccio
ACE Emeritus
ACE Emeritus

Love spatial challenges!

 

スポイラ
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.