This documentation supports the 21.3 version of Action Request System.

To view an earlier version, select the version from the Product version menu.

Including statistics in a custom AR System report

  1. Open the ReportCreator form, and click the Statistics tab.
  2. From the Operation list, select the operation:
    • Count—Tallies the number of requests.
    • Sum—Adds up specified fields or the arithmetic relationship among fields.
    • Average—Calculates the average of specified fields.
    • Minimum—Calculates the minimum value for a specified field.
    • Maximum—Calculates the maximum value for a specified field.
      Except for Count, these operations can be applied only to numeric and date/time fields. Each operation can apply to the whole report, or to a group of requests in a report. Groups are defined on the Sorting tab.
  3. From the Expression list, select a field to include as part of a statistic.
    An expression is required for all statistical operations, except Count. Whether you include an expression for a Count operation depends on how you want rows with null values to be counted.
    If you are defining a Count operation that includes an expression, only rows with a value that is not null for the specified expression are counted when the report is run. If you are defining a Count operation that does not include an expression, all rows returned are counted, including those with null values.
    The menu list displays all numeric or date fields in the form. Expressions can include any of the following values:
    • Numeric fields
    • Date fields
    • Status history fields
    • Keywords
      The most commonly used keywords are $DATE$$NULL$$TIME$$TIMESTAMP$$USER$, and $WEEKDAY$. Keywords are case-sensitive and must be entered in all capital letters.
      For reports to run properly in a browser, you must add a backslash to the keyword in the Expression field, for example, $\TIMESTAMP$.

    • Numbers
      You can type numbers directly into the Expression field, for example, 5.25, 33, and so on.
    • Arithmetic operators (+-, **, */, and % )
      You can type arithmetic operators directly into the Expression field, similar to the way they are entered in the advanced search bar.
  4. In the Label field, type the label to identify a statistic on the report. You can include any of the following control characters in a label field:

    \b

    Backspace

    \n

    Return

    \t

    Tab

    Backslash

    \nnn

    ASCII character


  5. From the Compute On field, select the scope of a statistic:
    • Report—Calculates the statistic for all entries in the report. The statistic appears at the end of the report.
    • GroupN—Calculates a statistic for groups defined on the Sorting tab. The statistic appears below each group.
  6. (Windows only) From the Layout list, select one of the following options to specify how you want the results to be displayed in the report:
    • Single—Displays all the statistical results on one line.
    • Multiple—Displays each statistical result on its own line.
    • Column—Displays the result for each value at the bottom of the column of the field specified in the Expression field. Column is valid only for a column-formatted report.
      The Layout field setting works with the Compute On setting to determine where a statistic appears on a report.

Where to go from here

Defining custom AR System reports

Was this page helpful? Yes No Submitting... Thank you

Comments