3 Replies Latest reply on Jul 6, 2018 3:29 AM by meenu choudhary

    Warehouse KPI's

    David Konjetic

      Hi

       

      We want to know how we can masseur our warehouse on the volume and KPI.

      first on the volume we want t know how we can measure on weekly basis how many lines where Release to the warehouse, packed and shipped.

      secondly on the KPI's with the below rule's

      we have managed this to be calculated in Excel but i can't do it in Tableau

       

            

      Freight TermsPriorityReleasedLinesRule packing OTDRule shipping OTD
      DDPP2before noon<15pack date = release date + before 15:00ship date = release date
      P3before noon>15on time, apart from exception liston time, apart from exception list
      after noon<15/>15on time, apart from exception liston time, apart from exception list
      URGENTafter noon<15/>15pack date = release dateship date = release date, apart from exception list
      DAP/CIPP1before noon<15pack date = release date + before 15:00ship date = release date, apart from exception list
      P3before noon<15/>15on time, apart from exception liston time, apart from exception list
      P3after noon<15/>15on time, apart from exception liston time, apart from exception list
      URGENTafter noon<15/>15pack date = release dateship date = release date, apart from exception list
      ExW/FCA/COLLECTP1before noon<15pack date = release dateon time, apart from exception list
      P3before noon<15/>15on time, apart from exception liston time, apart from exception list
      after noon<15/>15on time, apart from exception liston time, apart from exception list
      URGENTbefore noon<15/>15pack date = release dateon time, apart from exception list
      after noon<15/>15pack date = release dateon time, apart from exception list