Calculating the Detect stop

[ajsjoshua]

Hi all,

I want to calculate how many DETECT STOP occured during production of Lower Arm and for  Housing.

Expecte output:

For Lower Arm : 1 DETECT STOP

For Housing      : 5 DETECT STOP

MachineNumber	Start	Stop	Program	CoolantPumped	RPM	OpID
1	07:30	08:00	Lower Arm	22	2000	4
1	08:10	08:50	Lower Arm	47	8000	4
1	08:30	08:40	DETECT STOP	0	0	4
1	09:15	09:40	Lower Arm	24	2200	4
1	09:47	10:23	Lower Arm	22	2000	4
1	10:35	11:05	Lower Arm	27	2300	4
1	11:22	11:52	Lower Arm	23	2000	4
1	13:05	13:33	Lower Arm	23	2000	4
1	13:41	14:05	Lower Arm	23	2000	4
1	14:15	14:38	Lower Arm	30	3500	4
1	15:40	16:08	Lower Arm	23	2000	4
1	16:15	16:45	Lower Arm	23	2000	4
2	07:05	07:10	Housing	5	9717	3
2	07:11	07:13	Housing	5	10398	3
2	07:16	07:21	Housing	5	9988	3
2	07:27	07:30	Housing	5	10900	3
2	07:38	07:42	Housing	5	10184	3
2	07:49	07:54	Housing	5	9925	3
2	08:00	08:03	Housing	5	10533	3
2	08:11	08:13	Housing	5	10731	3
2	08:22	08:24	Housing	5	10862	3
2	08:33	08:35	Housing	5	10859	3
2	08:44	08:49	Housing	5	9018	3
2	08:55	09:00	DETECT STOP	0	0	3
2	09:06	09:17	Housing	5	9171	3
2	09:17	09:22	DETECT STOP	0	0	3
2	09:28	09:33	Housing	5	9278	3
2	09:39	09:44	DETECT STOP	0	0	3
2	09:50	09:55	Housing	5	9855	3
2	10:01	10:06	DETECT STOP	0	0	3
2	10:12	10:17	Housing	5	9567	3
2	10:23	10:28	Housing	5	9511	3
2	10:34	10:39	Housing	5	9781	3
2	10:45	10:50	Housing	5	9999	3
2	10:56	11:01	Housing	5	9538	3
2	11:07	11:09	Housing	5	10990	3
2	11:18	11:23	Housing	5	9274	3
2	11:29	11:34	DETECT STOP	0	0	3
2	11:40	11:43	Housing	5	10313	3

[tresesco · Accepted solution]

Chart: Straight Table

Dimension: Pick(Match(MachineNumber, 1,2), 'Lower Arm', 'Housing')

Exp: Count( {<Program={'DETECT STOP'}>} Program)

The dimension could be dynamic if you maintain a MachineNumber-Program mapping.

[ajsjoshua]

Dear  tresesco

Thank u very much.