Johan de Groot | Antichaos

Blog

  • Year-to-date in Tableau

    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]) <= DATEPART('dayofyear',TODAY())

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

    YEAR([Date]) >= YEAR(TODAY())-1
AND (MONTH([Date]) < MONTH(TODAY())
OR
(MONTH([Date]) == MONTH(TODAY())
AND DAY([Date]) <= DAY(TODAY())))

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

    YEAR([Date]) >= YEAR(TODAY()-1)-1
AND (MONTH([Date]) < MONTH(TODAY()-1)
OR
(MONTH([Date]) == MONTH(TODAY()-1)
AND DAY([Date]) <= DAY(TODAY()-1)))
  • ISO weeks in Tableau

    ISO weeks in Tableau

    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. 

    (more…)

  • Calculate last day of month

    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…

    (more…)

  • Top 2000 – 2016

  • Look who’s talking

    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.

  • Look who’s talking

    Look who’s talking

    Vrouwen worden steeds belangrijker in films. In 2016 hadden we Jyn als het belangrijkste karakter op de Star Wars posters, Harley Quin leidde zo’n beetje de Suicide Squad en Black Widow is al weer een paar jaar geleden neergezet als power-vrouw in het Marvel universum.

    De ruimte die ingericht wordt op de posters voor vrouwen komt niet bepaald overeen met de tijd dat zij aan het woord zijn. Alleen Dory babbelt zichzelf er doorheen.

  • Top 2000 – 2014

  • Top 2000 – 2012

  • Top 2000 – 2011

    Top 2000 – 2011