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 v3, 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 v3 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 v3 Show function
In v3, 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 v3 Show aggregate function for a query.
To create a v3 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.