An aggregate is a function where the values of multiple rows are grouped together as input on specified criteria to form a single value of more significant meaning or measurement.
In 2.x, you specify an aggregate for a query in a Measure.
In 3.x, Show provides aggregate function options for a query, followed by Filtered to options.
This article shows you how to specify a 2.x Measure aggregate for a query, then how to specify a 3.x Show function for a query.
Using a 2.x Measure aggregate
Within each 2.x Measure you can specify aggregators for a query, such as Count (Events or Unique), Sum, Average, Median, Minimum, to name a few. This section demonstrates how to specify a 2.x Measure aggregate for a query.
To create a 2.x Measure aggregate, do the following:
- Click the Explorer icon in the left menu bar. The Explorer window appears.
- Select a Dataset and the type of View in which to display the results.
- Specify a Start and End time over which to analyze the data for the query.
- Under Measure, select an aggregator from the drop-down list.
- Optional: Add another Measure and/or specify a Compare.
- Click GO and view the results in the window on the right.
Using a 3.x Show function
In 3.x, you can specify an aggregate function with Show, such as Count (Events or Unique), Sum, Average, Median, Minimum, to name a few. This is followed by a filter to (For) options. This section demonstrates how to specify a 3.x Show aggregate function for a query.
To create a 3.x Show function, do the following:
- Click the Explore icon in the left navigation bar, then select a dataset from the drop-down list. We chose the movies dataset for our example.
- In Set 1, accept Show, then select an aggregate function option from the drop-down list, select a property (on which to apply the aggregator) from the drop-down list, then specify a Filtered to option.
In our example we chose count of events to be Filtered to all events.
- Select the set 1 text and enter a meaningful name. In our example, we entered Count of events.
- Optional: In set 2, accept Show, select an aggregate function, property (on which to apply the aggregator), and Filtered to option. Then, select the set 2 text and enter a meaningful name for the set. In our example, we entered Sum.
In our example, we selected to Show sum of timestamp Filtered to all events.
- Optional: Specify a Split by (similar to Group by in 2.x) function. In our example, we chose to Split by action.
- Specify Starting and Ending times, and then click GO. For a Start time, we entered 180 days ago. For and End time, we entered now.
We received the following results for our example.