Tabular Reports › Variable Options › RATE OPTION-Display a Rate Instead of a Count

RATE OPTION-Display a Rate Instead of a Count

Use the RATE option with a variable that usually displays a count to display the rate for that variable.

Example: Sample Commands

The following commands produce a report that displays the transaction usage of all active transactions by transaction ID. The RATE option is used to give the transaction rate (number per second) also.

EACH 1 DAY
TAB DATE TRAN USE      TRANID(CINQ) HDR1(CINQ) HDR2(USE)      AND,
         TRAN USE DIFF TRANID(CINQ) HDR1(CINQ) HDR2(%CHANGE)  AND,
         TRAN USE RATE TRANID(CINQ) HDR1(CINQ) HDR2(RATE)     AND,
         TRAN USE      TRANID(PINQ) HDR1(PINQ) HDR2(USE)      AND,
         TRAN USE DIFF TRANID(PINQ) HDR1(PINQ) HDR2(%CHANGE)  AND,
         TRAN USE RATE TRANID(PINQ) HDR1(PINQ) HDR2(RATE)
 END
RUN

A report like the following is generated:

-          CINQ      CINQ   CINQ     PINQ     PINQ   PINQ
- DATE     USE     %CHANGE  RATE     USE    %CHANGE  RATE
-------- -------- -------- ------ -------- -------- ------
01/08/08    2,978           0.03    12,778           0.15
01/08/08    5,304   +78.1%  0.06    16,861   +31.9%  0.20
01/04/08   30,734  +479.4%  0.36    35,452  +110.2%  0.41
01/05/08   38,711   +25.9%  0.45    52,322   +47.5%  0.61
01/06/08    2,113   -94.5%  0.02       395   -99.2%  0.00
01/07/08      417   -80.2%  0.01     1,610  +307.5%  0.02
-------- -------- -------- ------ -------- -------- ------
 PERIOD    80,257           0.16   119,418           0.24
-------- -------- -------- ------ -------- -------- ------

This report shows that in the 86,400 seconds on 01/08/08, transaction CINQ was executed 2978 times, which is a rate of 0.03 times per second.