Showing the Skylines of cities in Tableau – one by one.
The visualisation below is set on ‘auto-play’ (using the Tableau Javascript API) – if you want to travel around the world on your own pace you can start here.
Voor de editie van 2020 heb ik dit keer niet gekozen voor een extreem fancy datavisualisatie met uitgebreide data-preparatie en/of ingewikkelde wiskundige formules, maar wat meer nadruk gelegd over hoe je met relatief eenvoudige grafische elementen je een dashboard een compleet ander uiterlijk kunt geven dan een ‘standaard’ dashboard.
Klik op de visualisatie om deze full-screen te bekijken – en vooral te gebruiken!
When you are creating a calculated field in Tableau Desktop, Server of Prep you might want to create some comments to help others see what the purpose of this field is, or explain the calculation that you made. In other situations you might want to test a line of code, and disable a previously written block of code without deleting it.
This is all possible using comments in calculated fields.
[Read more…] about Comments in TableauIf you experience 502 errors when downloading large datasets from Tableau Server – either in a browser or Tableau Desktop – you might occur problems not related to Tableau Server, but a proxy or gateway in front of the server.
[Read more…] about 502 errors on datasource downloads from TableauIf 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)))