11 Replies Latest reply on Mar 21, 2018 3:19 AM by ade aiyeola

    Excluding Holidays and weekends  in Tableau

    dinesh reddy

      hi,

       

      i am able to exclude weekends. Now i need to exclude public holidays from the same code.

      Foe excluding weekdays i used below logic

       

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

      +

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

      -

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

       

      and now i want to exclude holidays from the above calculated field.