Using Measures in Measure IQ
Use measures to create queries in Measure IQ to aggregate your data in different ways. Take a few minutes to review the aggregation options available in Measure IQ. You will be working with them when you create queries. Measure IQ v5 includes the following options:
| Measure Aggregation | Used in | Description | Notes |
|---|---|---|---|
| Count Events | - Explorer - Properties - Flows | A simple count of events matching the query. | See Show a count of events or Show a count of actors. |
| 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, Measure IQ 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, Measure IQ 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. | |
| Every | - Properties | Create an actor or flow property that contains a list of values in a given column. | - See Compare actor or flow properties on the fly with sets. |
| Variance | - Explorer | The statistical variance of a random value in the given numeric column from the column’s average (mean) over the specified time period. | - Does not work with string columns. |