2 Replies Latest reply on Dec 22, 2016 6:56 AM by Łukasz Majewski

    Networkdays in Tableau 10 - Caculate business days excluding weekends and holidays (based on a business unit)

    dana.dang

      Hello,

       

      I have two files: ODBC and excel file of just holidays. I was able to calculate weekdays and exclude weekends from the ODBC file using the following formulas. Now I would like to exclude the holidays from the excel file. Please advise how that should be done using two different data sources.

       

      DATEDIFF('week',[Event Start Date],[End Time]) *5

      +

      MIN(DATEPART('weekday',[End Time]),6)

      -

      MIN(DATEPART('weekday',[Event Start Date]),6)

       

      I read several discussions from the forum and still could not find a solution.