Data Table

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'.

Analyze Data

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.

Customize Appearance

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.

General Settings

1. 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'.

   

2. 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.

   

Advanced Settings

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.