Breakdown time

[ajsjoshua]

Hi all,

I want to calculate the breakdown time

ex:the breakdown time for machine 1 is 10 min

MachineNumber	Start	Stop
1	07:30	08:00
1	08:10	08:50
2	08:30	08:40
2	09:15	09:40
3	09:47	10:23
3	10:35	11:05
3	11:22	11:52

[ajsjoshua]

Hi Peter Cammaert  crusader_stalwar1

Suggest me some ideas

MachineNumber	Start	Stop	Program	Breakdowntime
1	07:30	08:00	Lower Arm	00:10:00
1	08:10	08:50	Lower Arm	00:25:00
1	08:30	08:40	DETECT STOP	00:00:00
1	09:15	09:40	Lower Arm	00:07:00
1	09:47	10:23	Lower Arm	00:00:00

IF DETECT STOP comes it should not consider it.

Regards,

Joshua.

[sunny_talwar · Accepted solution]

May be this:

Table:

LOAD * INLINE [

    MachineNumber, Start, Stop, Program, Breakdowntime

    1, 07:30, 08:00, Lower Arm, 00:10:00

    1, 08:10, 08:50, Lower Arm, 00:25:00

    1, 08:30, 08:40, DETECT STOP, 00:00:00

    1, 09:15, 09:40, Lower Arm, 00:07:00

    1, 09:47, 10:23, Lower Arm, 00:00:00

];

Left Join (Table)

LOAD MachineNumber,

  Start,

  Stop,

  Interval(If(MachineNumber = Previous(MachineNumber),  Peek('Start') - Stop)) as Breakdowntime_Calculated

Resident Table

Where Program <> 'DETECT STOP'

Order By MachineNumber, Start desc;

[sunny_talwar]

Or this to get 0's for where I currently have nulls

Table:

LOAD * INLINE [

    MachineNumber, Start, Stop, Program, Breakdowntime

    1, 07:30, 08:00, Lower Arm, 00:10:00

    1, 08:10, 08:50, Lower Arm, 00:25:00

    1, 08:30, 08:40, DETECT STOP, 00:00:00

    1, 09:15, 09:40, Lower Arm, 00:07:00

    1, 09:47, 10:23, Lower Arm, 00:00:00

];

Left Join (Table)

LOAD MachineNumber,

  Start,

  Stop,

  Interval(If(MachineNumber = Previous(MachineNumber),  Peek('Start') - Stop)) as Breakdowntime_Calculated

Resident Table

Where Program <> 'DETECT STOP'

Order By MachineNumber, Start desc;

FinalTable:

NoConcatenate

LOAD MachineNumber,

  Start,

  Stop,

  Program,

  Breakdowntime,

  Interval(Alt(Breakdowntime_Calculated, 0)) as Breakdowntime_Calculated

Resident Table;

DROP Table Table;

[ajsjoshua]

Hi Sunny,

Excellant work

Its working Bro

Thank u.