Version 1.1 of my Alteryx formula add ins project has been released. These provide a set of utility functions for use wherever a formula can be used within Alteryx. The functions are developed in C++ and XML using the Alteryx SDK – I will write a few posts with the details of how to create…
Having created my simple framework for making custom C# based Alteryx tools, I thought I would release an initial version for people to take a look and try. Please note these are pretty experimental and while stable enough on my PC, I don’t have the resources of Alteryx to test widely and confirm stability. Please…
I am planning to do a blog series on extending Alteryx and various options that are provided to do this (but it takes me ages to write a post!). As part of learning some of the tricks for this I have been working on a set of Formula Addins (xml based)) and Custom DotNet Tools. I…
I was having a look at the public data the Met office provide on their website. They have a huge amount freely available on their website. I was interested in the historical data they provided for each of the stations accessible via this web page.The page allows you to download the data one station at…
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…
As a learning experiment I wanted to see if I could get Tableau to work as a basic graphics calculator. While mostly for fun, some of the techniques are quite useful for interpolation of sparse data. I had been playing with making Tableau generate interim points for creating a Sankey chart of the general election…
A question came up in one of our internal training sessions on Tableau. Mapping the question into the usual Superstore sample in Tableau, we wanted to create a table of the top 5 customers by total sales within a specified month and showing the percentage of the total sales they accounted for in that month.…
Having been looking forward to the Web Data Connector from the announcement at last years Tableau conference, I am currently enjoying trying out the Beta. With just some simple JavaScript you can wrap any web data into something directly accessible from the Data connections tab within Tableau. Starting with something I am familiar with, I thought…
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…
One of the most common data file formats I have to deal with is CSV files. Assuming your file is well formed (i.e. starts in the top row, with or without a header, in a nice continuous table), then there is no difficulty. Drag the file into Alteryx’s designer and it will create an Input…
James Dunkerley's Blog 