We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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 #98: SANTALYTICS 2017 - Part 2

jasperlch
12 - Quasar

Solution attached.

Natasha
9 - Comet

This was fun, wish I have done this earlier

 

Spoiler
Overlay is now my favourite tool from the reporting category, though I am not a fan of Alteryx reporting tools at all.
I struggled with making spaces in the first rows so went for the standard long if statement. 

Spent a lot of time trying to figure out correct spacing of the output file, and there is still something wrong with my column #13..

Screen Shot 2018-01-08 at 00.42.10.pngScreen Shot 2018-01-08 at 00.41.08.png 
lminors
9 - Comet

Still pretty iffy with the reporting tools. Alteryx is ridiculously intuitive until you meet those little browny/orange devils. Presented a good challenge nonetheless.

 

Spoiler
WC 98 solutionWC 98 solution

Luke Minors - Keyrus UK

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

Elena_Caric
8 - Asteroid
Spoiler
Periodic TablePeriodic TableWorkflowWorkflow

 I've never used most of the reporting tools, thanks to @LordNeilLord I was able to do it and understand how some work. Thanks! :-)

danilang
19 - Altair
19 - Altair

Wow!  Probably the most time consuming of the ~120 challenges that I done so far.  The reporting tools remind me of Slartibartfast's description of the coastline of Norway, "So many fiddly-bits and fjords"

 

Table.png

 

Spoiler
Shout out to @patrick_digan for the idea of of hard coding the layout for the 1st 3 rows.  So much easier than my first attempt of trying to insert blank images into an existing table.
Solution 98.png

 

Dan

kat
12 - Quasar
Spoiler
got some inspiration from Neil on how to nicely do the spacing for the first three rowsgot some inspiration from Neil on how to nicely do the spacing for the first three rows
JoBen
11 - Bolide

Cheers!

pasccout
8 - Asteroid

Here is my solution... displayed all images since I was not sure if that was the required outcome...

dsmdavid
11 - Bolide

Went for a slightly different route

 

Spoiler
Output:
Not so much periodic...Not so much periodic...Impressive what summarize can do.Impressive what summarize can do.

 

Still unable to upload my workflows here: https://dsmdaviz.com/wp-content/uploads/2018/11/solved%2398.yxzp