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  | 
  | A simple count of events matching the query.  | |
Count Unique  | 
  | A count of unique values within a column matching the query. This measure is valid for numeric and string data.  | 
  | 
Sum  | 
  | The sum of the numeric values of all results returned for a query.  | 
  | 
Average  | 
  | The average (mean) value of a given parameter over the specified time period.  | 
  | 
Minimum  | 
  | The lowest value that matched the query at any time over the specified time period.  | Does not work with string columns  | 
Maximum  | 
  | The highest value that matched the query at any time over the specified time period.  | Does not work with string columns  | 
Percentile  | 
  | The value at the selected percentile for a given parameter over the specified time period.  | Does not work with string columns  | 
First, Last  | 
  | 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.  |