Skip to main content
Skip table of contents

Measures

Use measures to create queries and knowledge objects.

Take a few minutes to review the measures available in Scuba. You will be working with them when you create queries. Scuba 4 includes the following default measures:

Measure

Used in

Description

Notes

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.

 

What's Next

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.