Wyn Enterprise User Guide
- An Introduction to Wyn Enterprise
- Document Portal for End Users
- Using Report Designer
- Create Static Report
- Create Tabular Report
- Create Parameterized Report
- Create Master-Detail Report
- Create Pivot Report
- Create Report with Chart
- Styles and Themes
- Expression Editor
- Report Templates
- Working with Dashboards
- Dashboard Designer
- Selecting a Dataset
- Data Attributes
- Dashboard Scenarios
- Charts and KPIs
- Calc Charts
- Containers and Components
- Dashboard Appearance
- Preview Dashboard
- Export Dashboard
- Data Analysis and Interactivity
- View and Manage Dashboards
- Governing Data and Resources
- Create Data Source
- Data Source Connections
- Create Dataset
- Create Semantic Model
- Secure Data Management
- Create Floor Plan
- Upload Resources
- Using Dashboard Designer
- Section 508 Compliance
Wyn Enterprise: Aggregation Methods
An aggregation method returns a summarized value by aggregating multiple values of a data attribute.
In Wyn Dashboards, default aggregation is automatically applied to binding measures to scenarios. You can change the default aggregation method to a method that most closely helps you in deriving the metric.
Aggregation is performed on binding the measures to Values. When binding measures, six aggregation methods are available. The default aggregation method for measures is Sum. For dimensions, only two aggregation methods are available: Count and Distinct Count. The default aggregation method for dimensions is Count.
The below table lists all the aggregation methods.
|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|
Apply Aggregation Method to a Data Attribute
- Go to the Data Binding tab .
- Under Values section, go to the attribute's settings and select Aggregation Method.
Select an aggregation method to apply to the bound attribute. The following image shows the six aggregation methods available for a measure.
There are only two aggregation methods for a bound dimension.