Skip to main content

Scuba Version 2 Guides

You are viewing the documentation for Interana version 2. For documentation on the most recent version of Interana, go to docs.interana.com.

 

Scuba Docs

Measures reference

  1. Last updated
  2. Save as PDF
0votes
13updates
357views
Neal
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
  • Query Builder
  • Cohorts
  • Metrics
  • Sessions
 A simple count of events matching the query.  
Count Unique
  • Query Builder
  • Cohorts
  • Metrics
  • Sessions
 A count of unique values within a column matching the query. This measure is valid for numeric and string data. 

 
Sum
  • Query Builder
  • Cohorts
  • Metrics
  • Sessions
 The sum of the numeric values of all results returned for a query.
  • Does not work with string columns
  • When used with session metrics, Interana sums per session for session IDs within the query's event filters.
Average
  • Query Builder
  • Cohorts
  • Metrics
  • Sessions
 The average (mean) value of a given parameter over the specified time period.
  • Does not work with string columns
  • When used with session metrics, Interana averages per session for session IDs within the query's event filters. 
Median
  • Query Builder
  • Cohorts
  • Metrics
  • Sessions
 The median value (50th percentile) of a given parameter over the specified time period.

Does not work with string columns
Minimum
  • Query Builder
  • Cohorts
  • Metrics
  • Sessions
 The lowest value that matched the query at any time over the specified time period.

Does not work with string columns
Maximum
  • Query Builder
  • Cohorts
  • Metrics
  • Sessions
 The highest value that matched the query at any time over the specified time period.

Does not work with string columns
Percentile
  • Query Builder
  • Cohorts
  • Metrics
  • Sessions
 The value at the selected percentile for a given parameter over the specified time period.
  • Does not work with string columns
  • Interana computes percentile metrics to be precise to within 1/1000 of the returned result. For example, a result between 1 and 1000 will be precise to the nearest integer, and a result of 1,000,000 will be precise to the nearest 1,000.
Ratios
  • Query Builder
  • Cohorts
  • Metrics
  • Sessions
 Ratios divide the result of one measurement by the result of another.

Does not work with string columns
First / Last
  • Query Builder
  • Cohorts
  • Metrics
  • Sessions

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:

  • Time
  • Table
  • Number
  • Bar
  • Pie
  • Stacked Area Time