[]
        
(Showing Draft Content)

Aggregation Methods

An aggregation method returns a summarized value by aggregating multiple data attribute values.


In Wyn Dashboards, default aggregation is automatically applied to binding measures to scenarios. You can change the default aggregation method to one that most closely helps you derive the metric.


Aggregation is performed by binding the measures to Values. The default aggregation method for measures is Sum. Only two aggregation methods are available for dimensions: Count and Distinct Count. The default aggregation method for dimensions is Count.


The below table lists all the aggregation methods available in Wyn Enterprise.

Aggregation Method

Description

Sum

Returns the sum of all the values in an attribute

Average

Returns the average value in an attribute

Min

Returns the minimum value in an attribute

Max

Returns the maximum value in an attribute

Count

Returns the number of values in an attribute

Distinct Count

Returns the number of unique values in an attribute

First

Returns the first value in an attribute

Note: The aggregation method First, is only applicable for the Color data attribute on Bubble Maps and Area Maps. Refer to the Bubble Map, and Area Map articles for more details.

Apply Aggregation Method to a Data Attribute

  1. Navigate to the Data Binding tab Data Binding Icon.

  2. Under the Values or Tooltip section, click the attribute's settings icon Properties Icon and select an aggregation from the Aggregation Method menu.

    Aggregationmethod-databinding


    There are only two aggregation methods for a bound dimension.

    Aggregationmethod-boundDimension


  3. When selecting the First aggregation rule, a First Aggregation Setting popup will prompt you to define the sorting criteria. From the Sort By dropdown, choose a data field, and then select the sorting order - either Ascending or Descending - from the Sort Order dropdown. Click Ok to confirm and apply.

    Aggregationmethod-FirstAggSetting