Alteryx Designer v11–My Initial Thoughts

Alteryx has released version 11 of both the designer and the server. It has a lot of nice improvements and few changes worth being aware of. I don’t use the server so this post is just going to concentrate on the designer and the features I have noticed. The move towards HTML5 based property panels…

Alteryx Abacus – version 1.2

Updated the links to versions 1.2.1 as a file was missing from 1.2 The latest release (version 1.2) of my Alteryx formula add-ins project (now called Alteryx Abacus with thanks to Chris Love) is now available. These are a set of utility functions for use wherever a formula can be used within Alteryx. The functions…

Rounding Calculations in Tableau (and Excel and Alteryx)

I was doing some table calculations in Tableau and needed complete control over the rounding that was used. Tableau provides a single ROUND function. The exact specification of this (I believe) depends on the data source you are connected too, as it passes through to the underlying server. I needed to be able to look at…

Downloading FTSE Data From Yahoo! and Quandl using Alteryx

Following on from another post on downloading Quandl into Tableau via Python and the Data Extract API, I wanted to try downloading the current components of the FTSE 100, and then for each one download the history of prices using Alteryx. Yahoo! finance has a web page with the members of the index: The list…