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
Data Table is a standard table layout that displays the data in a tabular form along with the column headers. You generally use a data table to view the original data of the dataset. Note that you cannot edit the data in a data table.
Design a Data Table in Wyn Enterprise
From the Dashboard Toolbox, open the Data Visualization node and drag-drop the Data Table scenario onto the design area.
Bind Dataset to Data Table Scenario
With the scenario selected, from the Data Binding tab, select the dataset. Once the dataset is successfully loaded in the designer, the data binding panel automatically expands and displays the data attributes available in the dataset.
The following image shows the data table scenario bound to the 'RetailDataset' dataset.
On dragging and dropping the data attributes to the Columns data binding area of the scenario, the table is plotted accordingly, along with a default table title.
Format Data Attributes
You can format the data attributes in a dataset by performing a variety of operations such as renaming, modifying data format and display unit, creating a hierarchy field, applying an aggregation method, etc. Using these operations, you can control the display of data attributes in a scenario.
For more information about these operations, see Data Attributes.
In the following data table scenario, the data format for the data attribute is modified to display the unit prices in 'currency'.
Wyn Dashboards scenarios support rich data analysis and exploration capabilities that can help analyze massive amounts of information and make data-driven decisions. For example, adding filters to scenarios, sorting data, and applying conditional formatting. Note that you can apply all these operations using the Action Bar corresponding to each scenario in the designer.
For more information, see Data Analysis and Interactivity in Dashboards.
The following image shows the filtered data in the data table scenario - the filtering is applied on data to exclude the two countries, China and Japan.
You can customize the default data table appearance by setting properties in the Inspector tab of the scenario such as adding a border, adjusting text alignment, renaming table title, changing background color, enabling automatic scrolling, etc.
Modify Data Stripes
Wyn Enterprise uses default colors for the alternate data stripes in a data table scenario. To change the default color, use the Background Color properties for the first and second data stripes and set them to a suitable color from the color palette. Also, you can disable the alternate row style in the table by setting the Use Alternate Row Style to 'False'.
Adjust Text Alignment
In Wyn Enterprise, you can easily manage the text alignment within the data tables by using the Text Alignment property in the Data Binding area.
Enable Automatic Scrolling
When your data table contains thousands of rows or even more, it becomes difficult to scroll through the data. In such cases, you can enable automatic scrolling using the Auto Scroll property and set the scrolling speed to either Slow or Fast. By default, the scrolling speed is set to Normal. You can also enable the automatic turning of pages when scrolling using the Page Turning property.
The data within the data table scrolls automatically on previewing the dashboard, as shown.