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. |