Commands › EACH Command-Define a Time Period

EACH Command-Define a Time Period

The EACH command defines a time period, from minutes to years, in which report data is organized. The effects of the EACH command depend on the report type, as follows:

• With tabular reports, use the EACH command to define the time interval you want the table to repeat. Create a DAY, DATE, or TIME column when you use the EACH command.
• For plot reports, use the EACH command to define the time period represented by each line in the plot. You can plot by the hour, day, week, or month using the EACH command. The default is one day.
• Graph reports break down activity by identifier during a given time period. If you do not specify an EACH command, the result is a single graph for the whole time period covered in the report. The EACH command produces a separate graph for each time period.

You must have the appropriate amount of data in your input file for the EACH value you specify. For example, you cannot specify EACH YEAR if your input file has data for less than one year. If the input file does not have enough data, you receive an incomplete report.

Important! The Report Writer cannot report on a smaller time interval than the data in the input file. This limitation is important when you use variables that use data collected at time intervals, such as interval variables. For example, if the input file contains data that was logged at half-hour intervals, you cannot specify an EACH value of less than 30 minutes. Generally, make the EACH value you specify the same as, or a multiple of, your system data collection interval. This warning does not apply to performance record data because such data is not collected at specified time intervals.

By default, a week is Monday through Sunday. You can set the weeks to begin on a different weekday. If you specify the EACH WEEK or EACH nnn WEEKs command, use the OPTION(WEEK=weekday) command to specify the first day of your week.

This command has the following syntax:

EACH [time-period | RECORD] [AVERAGED] [SUMMARIZE]

time-period

Defines one of the following base time units.

nnn

Specifies the number of time intervals (up to 999) in the time unit you select.

MINUTE: nnn minutes

HOUR: nnn hours

DAY: nnn days

WEEK: nnn weeks

MONTH: nnn months

YEAR: nnn years

Default: DAY

RECORD

Defines the sample interval as each record, rather than as a time interval. This option is valid only for HPLOT reports; if you specify EACH RECORD for any other report, the command is ignored.

If you specify EACH RECORD for an HPLOT report, then also use the SCALE operand to specify a scale for the HPLOT variable.

AVERAGED

Produces a report with one detail line for each period specified by the EACH command. The variable values in each line represent the average value of the variable for that period for all the input data.

For example, if you create a tabular report and specify EACH 1 HOUR AVERAGED, the report includes 24 rows. One row for each hour of the day. The first row would show the average value for each variable for the hour of midnight to 1:00 a.m. for all the days of input data.

When you use the AVERAGED operand, the EACH value must be 24 hours or less.

SUMMARIZE

Similar to the AVERAGED operand, except that the data is totaled instead of averaged. Use this operand only with variables that represent counts (not averages).

For example, if you specify EACH 1 HOUR SUMMARIZE for a tabular report, the report includes 24 rows, one for each hour of the day. The first row would show the total value for each variable for the hour of midnight to 1:00 a.m. for all the days of input data.

Examples: EACH Command

To plot the value of a variable for each half-hour period:

PLOT variable
  EACH 30 MINUTES
END
RUN

To create a distribution plot using each record as the sample interval:

VPLOT variable1
HPLOT variable2 SCALE(nn)
  EACH RECORD
END
RUN