You can include computed columns in your report.
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.
- 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.
- Select the Computed Columns option.
The operations supported for computed columns are:
- Select the type of calculation you want to perform from the Computed Columns sub menu.
- Select the column shown in the Results panel that contains the data you want to calculate computed values for.
|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.
The Log Explorer window shows the calculated column results.