Antichaos

Data Visualisation, Tableau & Data Services

Johan de Groot

Year-to-date in Tableau

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]) <= 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)))

Look who’s talking

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.

Look who’s talking

by Johan de Groot

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.