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: Sort
Sorting helps visualize dashboards by arranging the data in some meaningful order. Users can apply sort on the dimension values of a scenario in ascending or descending order. For example, you may want to sort the products by sales revenue to find the top-selling products.
Use the Sort dialog to specify the sort conditions. The available options in the Sort dialog are described as follows:
|Target Value||Refers to the value on which you want to apply the sort. Note that you can apply sort only to the bound dimensions|
|Items||Sorts the target field alphabetically.
Sort Order - Specify the sort order as Ascending or Descending.
|Value||Sorts the target field by measure values. Specify the Sort Order and Sort By.
Sort By - Select the measure from the list. Note that the list contains only the bound measures.
|Field||Sorts the target field by data attributes. Specify the Sort Order and Sort By.
Sort By - Select the attribute from the list. Note that the list contains both the bound and unbound data attributes.
|Manual||Use this option to create a custom sort order. Use the Up, Down, Top, and Bottom buttons to arrange the values in the list. Note that the list contains only the target field values.|
Note: Some dashboard items that do not support the sort feature are - KPI Chart, Indicator, Gauge, Data Table, Rich Text, Image, and Slicers.
Applying a Sort
- Select the dashboard scenario on which you want to sort the data. Note that an Action Bar automatically appears on the right of the selected scenario.
From the Action Bar, select Sort action.
In the Sort dialog that appears, click Add Sort to specify the sort conditions.
Set the Target Field to a suitable dimension from the list. For example, set the Target Field to 'Products' to apply sort on the 'Product' values.
- Choose the Value option since we are sorting the target field by the bound measure value, 'Revenue'.
Set Sort By to 'Sum of Revenue' from the list and Sort Order to either ascending or descending.
After specifying the sorting conditions, click Apply and then OK to see the result.