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

Open Trend Analysis

Check to enable trend analysis. For more information, see Trend Analysis.

Asset Aggregation

Available when trend analysis is enabled. Check to aggregate data on the same measurement for multiple assets.

Asset Parameter

Available when trend analysis is enabled. Enter the asset ID, and separate multiple assets with commas(,). Supports the use of placeholder parameters. For more information, see Configuring Parameters.

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 - Data Source

    • Position: select the position of enhancement contents, supporting left and right.

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

  • Icon - Rule

    • Position: select the position of enhancement contents, supporting left and right.

    • Icon Rule: select Edit Rule and configure matching type, style, and condition in the popup window.

  • Progress Bar

    • Progress Bar Style: select the style of the progress bar, supporting Bar and Stripe.

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

Open Trend Analysis

Check to enable trend analysis. For more information, see Trend Analysis.

Asset Aggregation

Available when trend analysis is opened. Check to aggregate data on the same measurement for multiple assets.

Asset Parameter

Available when trend analysis is opened. Enter the asset ID, and separate multiple assets with commas(,). Supports the use of placeholder parameters. For more information, see Configuring Parameters.

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.

Show Thousands Separator

Select this to display the thousandths of the value.


[1] Only available if Pagination is enabled.


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