calculate date diference of order dates and shipment date IF

[avishaiz]

I need hep with the following:

i want to make a stacked graph of the number of days it took to get the shipment in its different states:

order creation untill Bill of lading

Bill of lading untill arrival to factory

now there are several shipments from the same manufacturar and i want it to enable a drill down with the upper level being the avarege of time it took the manufacturer and a drill down to the spesific order data.

[dusasuman]

hi, Not clear with your requirement. Can you elaborate the requirement?

[Gysbert_Wassenaar]

Subtract the dates in the script to create a new field. Then create a chart with the average of that new field per manufacturer:

LOAD

  manufacturar,

  [order line number],

  [item number],

  [order creation],

  [order received],

  [bill of lading]

  Interval([bill of lading]-[order creation],'d') as Days_till_BoL,

  Interval([bill of lading]-[order received],'d') as Days_till_Delivery

FROM

     ...excel_file...

Dimension: manufacturar

First expression: avg(Days_till_BoL)

Second expression: avg(Days_till_Delivery)

[avishaiz]

i get the data from a ODBC and i want to get the data in the script

with the ability to drill down

[buzzy996]

use Interval() like Gysbert suggested.