2 Replies Latest reply on Apr 30, 2012 4:53 PM by Alex Kerin

    Average Number of Workdays

    Mike J

      Hi,

       

      I'm having trouble creating a calculated field to measure Average Number of workdays to close a record.

      We interpret this by taking the date the record was sent to us and counting the number of workdays it took to close it.

       

      This is the excel formula we currently use;
      IF(RecordSent="","",IF(RecordReturned="",((NETWORKDAYS(RecordSent,TODAY()))-1),((NETWORKDAYS(RecordSent+1,RecordReturned)))-1))

       

      RecordSent and RecordReturned are date dimensions.

      I tried ( [RecordReturned] - [RecordSent] ), but that's not working right.

       

      How can I recreate this formula on Tableau?

       

      Thanks,

      MJ