Computed Columns

You can include computed columns in your report.

Prerequisites

You must select a template that displays query results in the Log Explorer window.

You can show additional information alongside predefined log entry columns, corresponding to additional information stored in the client activity logs.

  1. Right-click the column header row to display the field names for the fields displayed in the Results panel.
    A right-mouse menu appears showing all the column names.
  2. Select the Computed Columns option.
    The operations supported for computed columns are:

    3. Operation

    Description

    Count

    Calculates the number of log entries for a value type, such as Count (Device Class) that shows how many log entries contain device information. Count (Any) shows the total number of log entries.

    Min

    Calculates the minimum value in a column for a set of results.

    Max

    Calculates the maximum value in a column for a set of results.

    Sum

    Calculates the sum of numerical data for a set of results; valid only for the File Size column.

    Average

    Calculates the numerical average of numerical data for a set of results; valid only for the File Size column.

    These operations do not apply to all columns.

  3. Select the type of calculation you want to perform from the Computed Columns sub menu.
  4. Select the column shown in the Results panel that contains the data you want to calculate computed values for.

The Log Explorer window shows the calculated column results.

Related Tasks