2 Replies Latest reply on Aug 1, 2018 12:33 PM by Jim Dehner

    Exclude holidays from aging calculations

    Patricia Munoz

      Hi Community!

       

      I am evaluating Tableau Prep as an alternative to Alteryx, a tool where we found a way to calculate the aging between two dates excluding holidays by adding as many rows as days between the two days less the holiday, and then aggregating everything but counting the number of rows. I don't know if Tableau Prep allows you to do something similar to that, or if you guys have found a way to exclude holidays to calculate agings. I currently have an excel sheet with all the holidays by country, so I can join them to my main data source by using the field country.

       

      Thanks in advance for any advice you may have.