• 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

Antichaos Blog

Use Python as an Alteryx connector

Johan de Groot · 2020-10-04 ·

Many people are kind of scared of using programming language. And sure, if you haven’t any experience using these ‘command line’ tools the learning curve may seem steep. And why should you learn a language like Python, if you have a fantastic tool like Alteryx to process your data?

[Read more…] about Use Python as an Alteryx connector

Top 2000 van Radio 2 — 2019

Johan de Groot · 2020-10-03 ·

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

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)))
  • « Go to Previous Page
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Go to Next Page »

Want to know more?. Contact

Antichaos

Copyright © 2022 Antichaos bv