7 Replies Latest reply on May 26, 2015 9:40 AM by Steve Mayer

    Calculating Networkdays with Tableau

    Paul Ozule

      Hi,

       

      I want to calculate/create a new measure "net workdays" for my time sheet reports from my date dimension. With excel i can just use the Net-workdays function: Net-workdays(Start Date, End Date) and i get a count. The number i get goes into 2 different calculation [(Monthly available hours (8 hours x net-workdays) and workday (total time entered divided by net-workdays)]. I want to give the users the ability to pick whatever date periods they want and these calculations adjust accordingly.