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
Quasar

Solution attached.

Natasha
Comète

This was fun, wish I have done this earlier

 

Révélation
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
Comète

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

 

Révélation
WC 98 solutionWC 98 solution

Luke Minors - Keyrus UK

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

Elena_Caric
Astéroïde
Révélation
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

 

Révélation
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
Quasar
Révélation
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
Bolide

Cheers!

pasccout
Astéroïde

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

dsmdavid
Bolide

Went for a slightly different route

 

Révélation
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