Blog

Year-to-date in Tableau

2017-06-30 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)))

ISO weeks in Tableau

2017-06-30 by Johan de Groot

Tableau can handle all kind of dates and dateformats very well – but one option is lacking: the use of ISO8601 weeknumbers, the one which is used all over the world, especially in Europe.

[Read more…]

Calculate last day of month

2017-06-20 by Johan de Groot

Sometimes you need to calculate how many days a certain month – like the current month. With some nested date-calculations this isn’t that hard to calculate…

[Read more…]

Top 2000 – 2016

2016-12-31 by Johan de Groot

Look who’s talking

2016-12-20 by Johan de Groot

Female actors are getting more important in movies. In 2016 we had Jyn as the most important Star Wars character on the Rogue One posters, Harley Quinn was the leader of the Suicide Squad according to the posters and Black WIdow seemed to be one of the most important character in the Marvel universe.

But the space female actors were given on the the posters are definitely not in line with the time they were allowed to speak. Only Dory was able to chat her way throughout the movie.