Setting the Table Time Period

Click on the Period menu on the left to determine the time period of the table.


"Start Time" and "Duration" determine the total period of the table. Selected Day means that when we run the table the user will be able to select a day from a calendar. We want to report on a single day so the duration is 1 day.

The interval length determines how many rows of data will be generated for each machine per day. If we set this to 1 Day then we will get a row per machine for the total utilization for that day. We can refine this down to 15 minute intervals but for now set this to 1 hour. This means we will get one row for every hour of the scheduled day (see earlier section on setting schedule). The "Day Start" field is set to TIME[DAYSTART] - this means the table will start at the beginning of the first shift.

The "Day End" is set to TIME[DAYEND] so the table ends at the end of the final shift.

If your first shift starts at 6 am and you run three shifts ending at 6 the next morning, the table above will run from 6 to 6, not from Midnight to Midnight.

The smaller interval title field determines the column period title on the table (this will default to time if you leave it blank. The large interval title field determines what is displayed in the period column (in this case the hour at the start and end of the interval - e.g. 06-07), the search icon gives a list of suggestions. If you set the large interval title to:

$INTERVALSTARTHH:$INTERVALSTARTM - $INTERVALENDHH:$INTERVALENDM

then the time will be displayed as 06:00-07:00 which is better.