Johan de Groot | Antichaos

Category: blog

  • Year-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: But this is a better one, since this compares day…

    Written by

  • Bohemian Rhapsody: From Top 2000 to jump-chart

    , ,

    Watch my presentation of the Top 2000 jumpchart, held on the Virtual User Group meeting on May 27th 2020:

    Written by

  • Use Python as an Alteryx connector

    , ,

    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?

    Written by

  • Use Python as an Alteryx connector

    , ,

    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?

    Written by

  • Top 2000 van Radio 2 — 2019

    , ,

    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… Dit jaar heb ik er voor gekozen om de beweging van de individuele titels…

    Written by

  • Top 2000 — 2018

    , ,

    (in Dutch…) Dit jaar heb ik er voor gekozen om de beweging van de individuele titels te benadrukken. Met behulp van een een ‘jump plot’ kun je weergeven hoe iets over een as heen beweegt – zoals een nummer door de Top 2000 jaren heen over de posities 1 tot 2000 – en vaak ook…

    Written by

  • 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 all dashboards, but well worth it) and transparent sheets:

    Written by

  • Calculate last day of month

    ,

    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…

    Written by

  • 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. 

    Written by

  • 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. 

    Written by