9 Replies Latest reply on Jan 14, 2019 6:59 AM by Tim Dines

    Target Date after excluding weekends and business holiday

    Ankit Goyal

      Hey guys!

       

      Fairly simple to do in excel, however, taking time to do it Tableau. I need to find a Target Date after excluding weekends and business holiday. This is what I have in data. Couldn't attach excel file due to security

       

      1. Review Date

      2. SLA as per category

      3. Holiday list

       

      can someone please help me do it. I'm using 10.2

       

       

      Holidays
      1/1/2019
      4/19/2019
      4/22/2019
      5/6/2019
      5/27/2019
      8/26/2019
      12/25/2019
      12/26/2019

         

      Review DateSLATarget Date
      1/4/201951/11/2019
      1/7/201931/10/2019
      1/4/201951/11/2019
      1/4/201951/11/2019
      1/8/201921/10/2019
      1/3/201931/8/2019
      1/2/201921/4/2019
      1/3/201951/10/2019
      1/3/201951/10/2019
      1/2/201931/7/2019
      1/8/201921/10/2019
      1/2/201951/9/2019
      1/5/201951/11/2019
      4/19/201934/25/2019
      4/19/201924/24/2019