Skip to main content
Interania

3.x Measures

0votes
10updates
32views

You use measures to create queries and knowledge objects. Take a few minutes to review the measures available in Interana 3.x. You will be working with them when you create Interana 3.x queries. Interana 3.x includes the following default measures:

Measure Used in Description Notes
Count Events
  • Explorer
  • Properties
  • Flows
A simple count of events matching the query.  
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, Interana 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, Interana 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. 

 

 

 

  • Was this article helpful?