- Getting Started
- Administration Guide
-
User Guide
- An Introduction to Wyn Enterprise
- Document Portal for End Users
- Data Governance and Modeling
- Working with Resources
- Working with Reports
-
Working with Dashboards
- Dashboard Designer
- Selecting a Dataset
- Data Attributes
- Dashboard Scenarios
- Dashboard Templates
- Component Templates
- 3D Scene
- Explorer
- Visualization Wizard
- Data Analysis and Interactivity
- Dashboard Appearance
- Preview Dashboard
- Export Dashboard
- Dashboard Lite Viewer
- Using Dashboard Designer
- Animating Dashboard Components
- Document Binder
- Dashboard Insights
- View and Manage Documents
- Understanding Wyn Analytical Expressions
- Section 508 Compliance
- Subscribe to RSS Feed for Wyn Builds Site
- Developer Guide
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
Navigate to the Data Binding tab .
Under the Values or Tooltip section, click the attribute's settings icon and select an aggregation from the Aggregation Method menu.
There are only two aggregation methods for a bound dimension.
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.