Table


The Table widget is used to display information in rows and columns.


../../_images/table.png


Data Fields


The data fields required are:


Field

Quantity

Dimension

0 - 2

Comparison

0 - 1

Measurement

Unlimited

Extension

Unlimited


Chart Style


Column Style


Format the appearance of each column. [1]


The modes available for each column are:

  • Normal: Basic mode that can be used for most columns.

  • URL: Displays column data as hyperlinks.

  • Hidden: Hides the column from view.

Normal


Field

Description

Decimal Places

Round up the values to the selected number of decimal places.

Enhancement

Select one of the following to add to all cells in the column and complete the additional configurations:

  • Icon

    • Position

    • Source: Select the data field which contains the icons.

  • Progress Bar

    • Progress Bar Style

Show Filter

Toggle between enabling and disabling filter options for each column. Filter button will appear in the header cells when enabled.

Formatting Rules: Font Color

Set rules to display different value colors for different values.

Formatting Rules: Background Color

Set rules to display different background colors for different values.

URL


Field

Description

Enter text

Toggle between entering the link display text manually or selecting a data field.

Redirection Method

Choose the redirection method when the link is clicked on.

Show Filter

Toggle between enabling and disabling filter options for each column. Filter button will appear in the header cells when enabled.

Formatting Rules: Font Color

Set rules to display different value colors for different values.

Formatting Rules: Background Color

Set rules to display different background colors for different values.


Note

Icon size is automatically aligned to the font size, under Content > Font.

Table Style


Content


Format the appearance of the entire table. [1]


Field

Description

Odd Row Color

Select a background color for odd rows.

Even Row Color

Select a background color for even rows.

Horizontal Border Color

Select a color for horizontal table borders.

Vertical Border Color

Select a color for vertical table borders.

Font

Style the values in the table.

Alignment

Set the table content alignment.

Total


Configure the function to use for the Total row, and format its appearance. This is normally used to find the subtotal or to show the average of the numerical values in each column. Non-numerical values in the column will be ignored.


Field

Description

Name

Specify the label for the aggregation row.

Aggregation

Select the aggregation method.

Position

Select the position to display the aggregation row.

Background Color

Select a background color for the aggregation row.

Font

Style the values in the aggregation row.

Alignment

Set the total row content alignment.

Layout


Configure how the table and the content is displayed.


Field

Description

Alignment

Choose how text is aligned for the entire table.

Enable Pagination

Toggle between paging or not paging the table.

Rows per Page [1]

Specify the number of rows per page. Default value is 50.

Transpose

Swap the rows and their corresponding columns.

Fixed Dimension Columns [2]

Enable or disable fixed dimension columns. After enabling, the dimension columns keep visible while the rest of the table scrolls.

Row Height

Specify the row height. Minimum and maximum value is 1 and 5 respectively. Supports up to two decimal places. Default value is 1.5.

Minimum Width of Last Column

Specify the minimum width of the last column. The default value is 120.


[1] Only available if Pagination is enabled.


[2] This function is not available for tables with sub tables.