Ieder jaar maak ik op basis van de laatste Top 2000 lijst van Radio 2 een nieuw (aantal) visualisaties.. De lijst zelf is niet heel erg spannend, dus is het interessant om te zien wat je met de data kunt doen…
[Read more…] about Top 2000 van Radio 2 — 2019Antichaos Blog
The Big Bang Theory meets other shows
Top 2000 — 2018
In my annual exercise of visualizing the Dutch Top 2000 I made use of a couple new Tableau tricks, like navigation buttons (a lot of work to create the on alle dashboards, but well worth it) and transparent sheets:
[Read more…] about Top 2000 — 2018Year-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
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…] about ISO weeks in Tableau