vRealize Log Insight provides several aggregation functions.

Type

Field

Description

Count

Events only

Creates a chart of the number of events for a specific query.

Unique count

Any field

Creates a chart of the number of unique values for a field.

Minimum

Numeric fields only

Creates a chart of the minimum value for a field.

Maximum

Numeric fields only

Creates a chart of the maximum value for a field.

Average

Numeric fields only

Creates a chart of the average value for a field.

Std dev

Numeric fields only

Creates a chart of the standard deviation for a field’s values.

Sum

Numeric fields only

Creates a chart of the sum of values for a field.

Variance

Numeric fields only

Creates a chart of the variance for the values of a field.

You can modify the way you view the query results.

View

Description

To group query results by specific field values

Use the second drop-down menu under the chart to group query results by specific field values rather than or in addition to time series.

To view the number of events for a field

For example, the number of events per host, deselect the Time series check box and select the check box for that field.

To view a stacked bar chart for a field with groupings over time

Select both the Time series check box and the field check box.