Blog

Save a Tableau workbook if you can’t save it

2020-10-29 by Johan de Groot

A small tip for a situation that is occurring once in a while to me (probably Mac specific):

If you have been working on a Tableau dashboard for quite a while, you suddenly can’t save the workbook anymore. ‘Save’ results in a popup which disappears very quickly, and ‘Save as’ shows the ‘save as’ dialog for a few milliseconds before disappearing again. Odd behavior – but especially annoying because you really want to save the changes you have made in the last two hours…

[Read more…]

Year-to-date in Tableau

2020-10-11 by Johan de Groot

If you want to compare last year to this year ‘to date’, you have to take into account that a leap-year adds 1 extra date to the year – so you can’t just compare the day-of-year from this and last year.

Often this filter is used:

DATEPART('dayofyear',[Date]) &lt;= DATEPART('dayofyear',TODAY())

But this is a better one, since this compares day and month:

YEAR([Date]) &gt;= YEAR(TODAY())-1
AND (MONTH([Date]) &lt; MONTH(TODAY())
OR
(MONTH([Date]) == MONTH(TODAY())
AND DAY([Date]) &lt;= DAY(TODAY())))

If you want to have a ‘year to date’ until today (so today excluded), use this one:

YEAR([Date]) &gt;= YEAR(TODAY()-1)-1
AND (MONTH([Date]) &lt; MONTH(TODAY()-1)
OR
(MONTH([Date]) == MONTH(TODAY()-1)
AND DAY([Date]) &lt;= DAY(TODAY()-1)))

Bohemian Rhapsody: From Top 2000 to jump-chart

2020-10-11 by Johan de Groot

Watch my presentation of the Top 2000 jumpchart, held on the Virtual User Group meeting on May 27th 2020:

Use Python as an Alteryx connector

2020-10-11 by Johan de Groot

Many people are kind of scared of using programming language. And sure, if you haven’t any experience using these ‘command line’ tools the learning curve may seem steep. And why should you learn a language like Python, if you have a fantastic tool like Alteryx to process your data?

[Read more…]

Use Python as an Alteryx connector

2020-10-04 by Johan de Groot

[Read more…]