Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to calculate the Count of each part produced by hour of the day.
PFA
Hi Joshua,
Does the below graph fulfills your requirement ?
I have created a custom field "Hour" in scripting to achieve this .
Script :
LOAD MachineNumber,
Start,
Stop,
Program,
CoolantPumped,
RPM,
OpID,
HOUR( DATE(Start,'h:mm:ss TT')) as Hour
FROM
HaasMachines.xlsx
(ooxml, embedded labels, table is Sheet1);
Hi
Is it like this ?
MachineNumber | Machines produced by hours |
---|---|
1 | 05:34:00 |
2 | 04:36:00 |
3 | 03:34:00 |
4 | 07:46:00 |
5 | 08:06:00 |
6 | 08:09:00 |
7 | 08:52:00 |
Hi Joshua,
Does the below graph fulfills your requirement ?
I have created a custom field "Hour" in scripting to achieve this .
Script :
LOAD MachineNumber,
Start,
Stop,
Program,
CoolantPumped,
RPM,
OpID,
HOUR( DATE(Start,'h:mm:ss TT')) as Hour
FROM
HaasMachines.xlsx
(ooxml, embedded labels, table is Sheet1);
Hi Pulikit,
It should be based on the hour of the day.
Ex: if time is 5pm how much program completed lik that i want to show
First Question :-Hour of the day will be based on Start or Stop Time.
Second Question :- condition for program completed ?