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)




      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.