Skip to main content
Interania

Using a 2.x Measure aggregate as a 3.x Show aggregate

0votes
21updates
87views
Elizabeth
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. 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.

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.

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:
  1. Click the Explorer icon in the left menu bar. The Explorer window appears.

WB_2.x_Explorer-icon.png

  1. Select a Dataset and the type of View in which to display the results.
  2. Specify a Start and End time over which to analyze the data for the query.
  3. Under Measure, select an aggregator from the drop-down list.

WB_2.x_Measure-aggregator.png

  1. Optional: Add another Measure and/or specify a Compare.
  2. 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:
  1. 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.
  2. 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.

WB_3.x_Aggregator_Set1.png

In our example we chose count of events to be Filtered to all events.

  1. Select the set 1 text and enter a meaningful name. In our example, we entered Count of events.
  2. 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.

WB_3.x_Aggregator_Set2.png

In our example, we selected to Show sum of timestamp Filtered to all events.

  1. Optional: Specify a Split by (similar to Group by in 2.x) function. In our example, we chose to Split by action.
  2. 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.

WB_3.x_Aggregator_query_results.png

 

  • Was this article helpful?