Clearly and Simply

Tag: date functions tableau

  • German Public Holidays in Tableau

    Calculated Fields in Tableau for German Public Holidays

    abgerissen - Photographer: Literaturarchiv Saar-Lor-Lux-Elsass (flickr.com)The previous post explained why color coding public holidays can be very effective for analyzing daily data, provided the Calculated Fields for all public holidays in the United States and included an interactive calendar for the US on Tableau Public.

    The Calculated Fields for the US public holidays are pretty straight forward and not too complicated.

    This can be different in other countries. And it sure is in my homeland. In Germany, all variable public holidays depend on Easter Sunday. And, if you read on, you will see that Easter Sunday requires a really complex calculation.

    Today’s post provides the Calculated Fields for all German public holidays and a German version of the interactive calendar on Tableau Public.

    (more…)

  • US Public Holidays in Tableau

    Calculated Fields in Tableau for US Public Holidays

    Calendar Round - Photographer: vbecker (flickr.com)For the analysis of daily data, the weekday can be an important and helpful additional information.

    For instance: if you are analyzing sales or order figures, incoming calls in a call center, internet usage, web statistics or the like, you will probably see significant differences in the data between working days, weekends and public holidays.

    Your views and dashboards should enable the reader to immediately distinguish between the three types, e.g. by color coding. This is pretty easy to do for the weekends, but it takes some additional efforts to include the public holidays, too.

    Today’s post explains why color coding daily data by the type of the day can be important for analysis and visualization. The article provides and describes Calculated Fields in Tableau for all US public holidays and put them to use in a Tableau Public dashboard showing an interactive calendar with all public holidays in the US between 1900 and 2099.

    (more…)