Measures reference
This applies tov2.25
Interana includes the following default measures that you can use with queries and named expressions:
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. |
|
Median |
|
The median value (50th percentile) of a given parameter over the specified time period. |
Does not work with string columns |
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. |
|
Ratios |
|
Ratios divide the result of one measurement by the result of another. |
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. |
You can use the First and Last measures to build queries and create named expressions. The First/Last measures are included in the Measure list for the following views:
|