Table

The Table widget allows you to organize and structure data from dimensions and apply measures to them. To build this widget, first add a table to your Data Model.

Widget Settings

In addition to the common widget settings, this widget has unique configuration options.

Data Settings

Dimensions and Measures

The following common settings are available for both dimensions and measures:

• Title
• Formula
• Format
• Formatting
• Width (in pixels or percentages)
• View
• Display (Always / By variable / By formula)

Additionally, for dimensions you can hide empty values and assign click actions.

View settings differ between dimensions and measures.

Dimension View

This parameter controls value coloring for dimensions in the table. Available options:

• No coloring
• Text coloring
• Cell background coloring

For dimensions with Integer or Float data types, when coloring is enabled, you can choose among By values, By rule, or By range. To define colors, click the gear icon in the style settings field. In the panel that appears, click + Rule.

From the dropdown list, select the value for which coloring is being configured. Color modes available: Solid or By rule.

Measure View

This parameter controls how measure values are colored in the table. Available options:

• Disabled (default)
• Text coloring
• Cell coloring
• Table coloring
• Table coloring by defined range
• Indicator with arrow (growth/decline)

When Table coloring by defined range is selected, minimum and maximum values for the View setting are set automatically:

• In Duration format: units of measurement appear as a hint in the range settings field
• In Number format: as the specified value

For aggregated indicators, chart settings are available:

• Minimum value (by default, the table’s minimum value is treated as 0%. Values at or below this threshold are considered 0%).
• Maximum value (by default, the table’s maximum value is treated as 100%. Values at or above this threshold are considered 100%).
• Units of measurement (for Duration format): days/hours/minutes/seconds

Formulas for dimensions and measures can be changed via a dropdown list. Detailed information about the formula editor is available on the corresponding page.

Display Settings

Text Size

Adjusts the text size within widget rows.

Alignment

Allows you to set vertical alignment of cell content to either the top or center. This setting affects all types of content in cells—text, checkboxes, colored bars, etc.

Table Header Settings

• Header background: Auto / Solid
• Font weight: Normal / Bold
• Text color: Auto / Solid

Row Limit

Limits the number of rows displayed per table page to the specified value.

Hide Empty Values

Hides empty values in the table.

Totals

When enabled, a Totals row is added to the table. The row displays the extreme value of the measure column, calculated using the same formula applied to the measure itself. For example, if the measure formula is min(...), the summary value will be the minimum across the entire column data range.

Additional settings for the Totals row include:

• Background (Auto / Solid)
• Font weight
• Text color

These settings are only available when the Totals row is enabled.

Filtering Settings

General filtering settings apply to this widget.

Action Settings

In the Buttons tab, you can configure script execution from the dashboard.

After selecting a script, a button appears above the table. Clicking it runs the script. Multiple actions can be added to a table, resulting in multiple buttons displayed above it.

Browse Mode

In Browse mode, you can search for specific values within a dimension directly in the table. The search field is located in the column header. You can find and select multiple values; once selected, a filter is applied to the entire dashboard—just as if you had clicked those values directly in the column.

Pagination is handled via a navigation panel in the bottom-right corner of the widget. This panel appears automatically when the number of rows exceeds the value set in the Row limit parameter.

Widget Configuration in YAML

You can configure the widget not only in the view but also in the YAML editor. The table below lists the keys and values available for configuration. For details on using the value key, see Dimension and Measure Values in YAML. Supported data formats are described on the corresponding page. General widget parameters are covered in Widget Configuration in YAML.

Data Settings in YAML

Dimensions and Measures in YAML (key: dimensionsAndMeasures)

To add a dimension or measure to the widget, use the dimensionsAndMeasures block. The keys below are used within this block.

Hierarchical Dimension (key: hierarchyDimensions)

Range in YAML (key: range)

Display Settings in YAML

Filtering Settings in YAML

Action Settings in YAML

Example of a Configured Widget in the YAML Editor

widgets:
  - key: table (1)
    apiVersion: "17"
    type: TABLE
    settings:
      titleColor:
        mode: AUTO
      titleSize: 14
      paddings: 8
      titleWeight: NORMAL
      textSize: 12
      filterMode: DEFAULT
      ignoreFilters: false
      stateName: null
      title: ""
      showMarkdown: false
      markdownMeasures: []
      markdownText: Description
      verticalAlign: TOP
      rowsLimit: 15
      dimensionsAndMeasures:
        - type: DIMENSION
          name: Application Number
          value:
            mode: FORMULA
            formula: '"case_table"."case_id"'
          dbDataType: String
          formatting:
            value: AUTO
            mode: BASE
          hideEmptyValues: false
          format:
            value: STRING
            mode: BASE
          onClick: []
          displayCondition:
            mode: DISABLED
          width:
            value: null
            mode: PIXEL
          displayMode: NONE
        - type: DIMENSION
          name: Service Type
          value:
            mode: FORMULA
            formula: '"case_table"."dir_services_def"'
          dbDataType: String
          formatting:
            value: AUTO
            mode: BASE
          hideEmptyValues: false
          format:
            value: STRING
            mode: BASE
          onClick: []
          displayCondition:
            mode: DISABLED
          width:
            value: null
            mode: PIXEL
          displayMode: NONE
        - type: DIMENSION
          name: Communication Channel
          value:
            mode: FORMULA
            formula: '"case_table"."intr_type"'
          dbDataType: String
          formatting:
            value: AUTO
            mode: BASE
          hideEmptyValues: false
          format:
            value: STRING
            mode: BASE
          onClick: []
          displayCondition:
            mode: DISABLED
          width:
            value: null
            mode: PIXEL
          displayMode: NONE
        - type: DIMENSION
          name: Start Time
          value:
            mode: FORMULA
            formula: '"case_table"."start"'
          dbDataType: String
          formatting:
            value: AUTO
            mode: BASE
          hideEmptyValues: false
          format:
            value: STRING
            mode: BASE
          onClick: []
          displayCondition:
            mode: DISABLED
          width:
            value: null
            mode: PIXEL
          displayMode: NONE
        - type: DIMENSION
          name: Completion Time
          value:
            mode: FORMULA
            formula: '"case_table"."finish"'
          dbDataType: String
          formatting:
            value: AUTO
            mode: BASE
          hideEmptyValues: false
          format:
            value: STRING
            mode: BASE
          onClick: []
          displayCondition:
            mode: DISABLED
          width:
            value: null
            mode: PIXEL
          displayMode: NONE
        - type: MEASURE
          name: Top user_name
          value:
            outerAggregation: count
            mode: AGGREGATION
            templateName: top
            processKey: null
            caseCaseIdFormula: null
            eventName: null
            eventNameFormula: null
            filters: []
            tableName: UserInfo
            columnName: user_name
            eventTimeFormula: null
          dbDataType: UInt64
          displayMode: NONE
          displayCondition:
            mode: DISABLED
          width:
            value: null
            mode: PIXEL
          format:
            value: NUMBER
            mode: BASE
          formatting:
            value: AUTO
            mode: BASE
      filters: []
      showTotal: false
      markdownTextSize: 26
      headColor:
        mode: BASE
        value: "#222F3E"
      headWeight: BOLD
      headTextColor:
        mode: AUTO
      totalTextColor:
        mode: AUTO
      totalWeight: BOLD
      totalColor:
        mode: AUTO
      actionButtons: []
    localApiVersion: "2"