Cumplimiento de Fechas

[#1]

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

[#2]

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

[mazacini]

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

[#4]

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];

[mazacini]

What about 'interval'?

Something like:

interval((T$DDAT$0-T$ODAT),'dd') as Timetaken