Alter.Nation
Community news, customer stories, and more!
Part 3
Share so loud and proud we hear it!
On Twitter on Community we wanna see it!
It's Santalytics time and we got the spirit!
Mad skills chillin, the solution's out
and that's what Community is all about!
The #SANTALYTICS fun is coming to an end! Part 3 asked us to make things a little more interesting for Santa by adding visual or interactive elements to our Periodic Table of Alteryx Tools visuals from Part 2 and we weren’t short on folks who rose to the challenge:
@patrick_digan led the charge with a solution a lot like our own! Taking his .htm visual from week 2, he added help links to his Periodic Table. Well done, Patrick!
@ggruccio, creating his original visual in Tableau, made his dashboard interactive by adding tool categories to filter to, as well as a tool tip with basic tool information! A unique approach that @Ilías put his own flair to in Alteryx.
Last, and certainly not least, @LordNeilLord submitted a visual that was jaw-dropping! Taking the Part 3 challenge to another level with creative use of webscraped Weekly Challenge data, he reorganized his visual to include workflow and tool data from live Community submissions!
Our Solution
Exercise 3 was fairly open-ended, so there were no right or wrong answers! We chose the route of making our visual more interactive by tweaking the HTML rendering of our Periodic Table of Alteryx Tools to open links (in new tabs) for first the Tool Mastery articles (if they exist), or the help files of each respective tool. In HTML, that’s as easy as finding the HTML object of your choice in the original visual (in this case, our tool images, by ID), and appending an <href> tag to either webpage. This was performed by first creating the HTML links from our Tool Mastery series via a quick webscrape of the Community Knowledgebase using the Download Tool:
With those links handy, we then added our help file links by hand and parsed through the original .htm document generated in Alteryx to find the tool image ids to join the <href> link tags to. Simple Join logic then allowed us to first join Tool Mastery links before resorting to joining help file URLs:
At this point our visual’s new .htm code was simply recombined (via the Summarize Tool) and rewritten to the original .htm document with the embedded <href> tags added that would make for easier navigation! We also automated a small .css script to be output to help zoom the visual for each user navigating to the final webpage:
Which was referenced via a short excerpt added to the header of our .htm:
At this point we rendered our solution, which can be viewed below!
Check out the live result hosted here!
Happy Holidays!!
Thank you for spending your holiday season with us, celebrating #SANTALYTICS!! An all-inclusive, non-denominational, festive excuse for some friendly competition using Alteryx, #SANTALYTICS has given us a new holiday to look forward to every winter season with you all. Happy Holidays, and best of luck in 2018!
We'll be taking a break from Weekly Challenge until January 8, 2018 when we go live with Challenge #100.
