4 Replies Latest reply: Sep 27, 2011 7:06 PM by Joe Kirwan RSS

    Cumplimiento de Fechas

      Buen dia,

       

      Apreciaria la ayuda para el siguiente caso:

       

      Tengo una tabla de Ventas con dos Fechas:

       

      1.- Fecha Orden

      2.- Fecha Entrega

       

      Lo que deseo hacer es que me muestre la Cantidad y Porcentaje de Ordenes que fueron entregadas en 5 dias o menos posteriores a la "Fecha Orden"

       

      Gracias anticipadas por la ayuda que puedan Bindarme.

       

      Would appreciate support for the following case: I have a table available with two dates:   1 .- Date Order 2 .- Delivery Date   I want to do is show me the number and percentage of orders that were delivered in 5 days or less after the "Order Date"   Thanks in advance for the help

        • Cumplimiento de Fechas

          Good Morning to all,

           

          I would appreciate support for the following case:

          I have a table available with two dates:
           
          1 .- Date Order

          2 .- Delivery Date

           
          Wath I want to do is show the number and percentage of orders that were delivered in 5 days or less after the "Order Date"
           
          Thanks in advance for the help

            • Cumplimiento de Fechas
              Joe Kirwan

              Create a new field in load to calculate the time taken to deliver

               

                   DeliveryDate - OrderDate as TimeTaken

               

              Then in a Straight Table

               

              Expression 1 - Total Orders, something like COUNT(ORDERS)

               

              Expression 2 - SET Analysis, Total Orders where Time Taken <6, something like COUNT({<TImeTaken<6}>}ORDERS).

               

              Expression 3 - Expression 2 / Expression 3 - in number tab, set to integer, percentage.

               

              You may need to modify above depending on data types for date and value fields.

               

              Joe

            • Cumplimiento de Fechas

              Hi Maczacini,

              2.- Expression 1 - Total Orders

                   COUNT(T$ORNO)

              3.- Expression 2 - Days

                   COUNT({<TImetaken<6}>}T$ORNO)

              4.- Expression 3 - Expression 2 / Expression 1

                    [Days]/[Total Orders]

               

              But didn´t work, when I substract the dates, It show me wronng values

               

               

               

               

               

              Thanks for your quick response, I just want to show how many orders was delivery in the firts 5 days after it Order date and How is the % for each month.

              Let me explain what I did, (DIMENSION = MONTHS)

              1.- Create a new field in load to calculate the time taken to deliver

                   LOAD  *inline [T$DDAT$O-T$ODAT as Timetaken];