[]
        
(Showing Draft Content)

Change the Aggregation Method for a Data Attribute

Change the Aggregation Method for a Data Field

Use aggregation methods to summarize data in your visualizations (e.g., Sum, Average, Count). By default, Wyn applies Sum to measures and Count to dimensions. You can change the aggregation type for each field to better fit your analysis.

Default Aggregation Methods

Data Type

Default Aggregation

Available Aggregations

Measure

Sum

Sum, Average, Min, Max, Count, Distinct Count, First

Dimension

Count

Count, Distinct Count

Apply an Aggregation Method

For a Measure or Dimension

  1. In the Data Binding panel, locate the Values section.

  2. Click the gear icon next to the field name of the data attribute you want to modify.

  3. Select Aggregation Method from the menu.

  4. Choose the method that best fits your needs.

Screenshot 2025-07-02 at 11.11.13 AM

For dimensions, only Count and Distinct Count are available.


If You Choose “First” (for Bubble Maps or Area Maps)

When selecting the First aggregation method:

  1. A First Aggregation Setting dialog appears.

  2. In the Sort By dropdown, select the field used to sort values.

  3. Choose Ascending or Descending in the Sort Order dropdown.

  4. Click OK to apply.

Note: The First aggregation method is only supported for the Color data attribute in Bubble Maps and Area Maps.

Aggregation Method Reference

Method

Description

Sum

Adds all values in the field.

Average

Returns the average (mean) of all values.

Min

Returns the smallest value.

Max

Returns the largest value.

Count

Returns the total number of values.

Distinct Count

Counts only unique values.

First

Returns the first value in the sorted data (see above).