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…
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…
Back in September last year, the Guardian published a fantastic visualisation looking at house price affordability in the United Kingdom. They took the Prices Paid data from the Land Registry and computed some descriptive statistics about it, such as the median and range. The raw data is easily available from data.gov.uk, and they provide monthly,…
This is in many ways related to the Beyond Alteryx Macros series, and how it all works will be described in detail in later posts within that series. This release is primarily a tidy up of the framework and fixing some naming mistakes in the code. It also includes the release of the first proof…
Last week, I attended the Alteryx Inspire Europe conference at Kings Place, London. This was the first time they had hosted the event outside of the US, and it was a great success with fantastic speakers and events, as well as selling out to over 400 people. The night before the conference kicked off, about…
In the first part of this series, I gave an overview of the Alteryx platform and some of the functionality offered by the SDK. The first parts of the SDK I am going to look at concern adding additional functions into the formula function library. There are two methods of doing this: XML Macro functions…
Alteryx has a huge built in set of tools (about 170 tools in v10.1 I think), but when something is missing or you just have a specific way you want to do something, it has various options on how you can extend it. The simplest way (and one of the most flexible ways) is to…
This posted started as a question on the Alteryx community about finding the nearest underground (subway if you prefer!) station to an address. I don’t have much experience working with addresses and map data, but thought their was probably a way leveraging the APIs Google maps provide. This feels very much like “standing on the…
Stealing this idea from Ken Black’s equivalent post on Tableau (sure he won’t mind!). As we have just had version 10.6 11.3 release think worth publishing a little guide on how to make Alteryx compatible with old versions! This comes up in the community a lot when answering questions and a user doesn’t have the…
There was an interesting question posted on the Alteryx community about which macro was best for calculating a weighted median. Adam Riley has a macro inside the CReW macros which does this, but wanted to see if it was possible to create one allowing dynamic selection of the grouping (like in a Multi Row Formula).…
James Dunkerley's Blog 