Things I’ve Made

Tableau


My Tableau Public profile is here, and there’s all kinds of stuff on there. Some of my personal favourites are:

Root, Williamson, Smith, and Kohli
Comparing the Big Four batsmen in modern Test cricket, with rolling averages and form comparisons.
190114 fab four

Different approaches to election mapping
Looking at the 2017 UK general election and how the same result can be conveyed differently depending on the mapping choice.
190114 election mapping

Gwilym’s bloody toll
An homage to the SCMP’s Iraq’s Bloody Toll visualisation, but with my own blood donation data.
190114 bloody toll

 

Alteryx


Dynamic Date Filter macro
This macro works much like a regular filter tool, with T and F outputs based on a filter condition. But instead of coding up a calculation like “DatePartYear([MyDateField]) = DatePartYear(DateTimeNow()) AND [MyDateField] <= DateTimeNow()” for a Year-to-Date filter, you can simply tick the Year-to-Date option. I built this with scheduled workflows in mind so that you can spend less time copy/pasting chunks of date filter code, and less time trawling through custom filter code when the year changes and the workflows break.
190114 dynamic date filter