Using Measures in Scuba [v5]

Count Events

• Explorer

• Properties

• Flows

A simple count of events matching the query.

See Show a count of events or Show a count of actors.

Count Unique

• Explorer

• Properties

• Flows

A count of unique values within a column matching the query. This measure is valid for numeric and string data. 

Sum

• Explorer

• Properties

• Flows

The sum of the numeric values of all results returned for a query.

• Does not work with string columns.

• When used with flow properties, Scuba sums per flow for flow IDs within the query's event filters.

Average

• Explorer

• Properties

• Flows

The average (mean) value of a given parameter over the specified time period.

• Does not work with string columns.

• When used with flow properties, Scuba averages per flow for flow IDs within the query's event filters. 

Minimum

• Explorer

• Properties

• Flows

The lowest value that matched the query at any time over the specified time period.

• Does not work with string columns.

Maximum

• Explorer

• Properties

• Flows

The highest value that matched the query at any time over the specified time period.

• Does not work with string columns.

Percentile

• Explorer

• Properties

• Flows

The value at the selected percentile for a given parameter over the specified time period.

• Does not work with string columns.

First, Last

• Explorer

• Properties

• Flows

The First and Last measures return the value of a given column with the smallest (First) or largest (Last) event timestamp. 

Every

• Properties

Create an actor or flow property that contains a list of values in a given column.

• See Compare actor or flow properties on the fly with sets.

Variance

• Explorer

The statistical variance of a random value in the given numeric column from the column’s average (mean) over the specified time period.

• Does not work with string columns.