• Skip to primary navigation
  • Skip to main content
Antichaos

Antichaos

Tableau Consultancy & Analytics

  • Home
  • Consultancy
  • Training
  • Antichaos Blog
  • About
  • Contact
  • NederlandsNederlands
  • Show Search
Hide Search

Johan de Groot

The Big Bang Theory meets other shows

Johan de Groot · 2020-09-03 ·

Top 2000 — 2018

Johan de Groot · 2018-10-25 ·

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 — 2018

Year-to-date in Tableau

Johan de Groot · 2017-06-30 ·

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

Johan de Groot · 2017-06-30 ·

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

Calculate last day of month

Johan de Groot · 2017-06-20 ·

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…] about Calculate last day of month
  • « Go to Previous Page
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Go to page 5
  • Go to Next Page »

Want to know more?. Contact

Antichaos

Copyright © 2023 Antichaos bv