4 Replies Latest reply on Feb 8, 2019 9:17 AM by Deepak Rai

    Help with a Date Calc

    David Lopez

      Hi Tableau Community,

       

      Was wondering if I could get help with the three calc fields, one is to get the most recent date <> "NEW", next is to get most recent stage <> "NEW", and finally a datediff from "new" to next min date that's only business days. Example table below and workbook is attached.

       

      UIDNew
      In Review
      Lead
      Offer
      Next Date after New
      Next Stage after NewDateDiff From New to Next Date after New (business days only)
      101/04/201901/13/201901/20/201901/13/2019In Review6
      201/03/201901/10/201901/10/2019Offer5
      301/05/201901/05/201901/06/201901/05/2019Lead1

       

       

      Happy to answer any questions, and as always appreciate any help.

       

      Cheers!