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 visually 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

  - key: table
    apiVersion: "16"
    type: TABLE
    settings:
      displayCondition:
        mode: VARIABLE
        variableName: null
        variableValue: null
      dimensionsAndMeasures:
        - displayCondition:
            mode: VARIABLE
            variableName: null
            variableValue: null
          dbDataType: STRING
          onclick: []
          name: Scenario
          format: STRING
          type: DIMENSION
          value:
            mode: FORMULA
            formula: '"case_table"."scenario"'
          formatting: AUTO
          onClick: []
        - displayCondition:
            mode: VARIABLE
            variableName: null
            variableValue: null
          color:
            mode: FORMULA
            formula: ""
          formattingTemplate: ""
          dbDataType: INTEGER
          name: Quantity
          format: NUMBER
          type: MEASURE
          value:
            mode: FORMULA
            formula: count(distinct "case_table"."incident_id")
          formatting: AUTO
          displaySign: FILL
        - displayCondition:
            mode: VARIABLE
            variableName: null
            variableValue: null
          formattingTemplate: ""
          dbDataType: FLOAT
          name: Duration
          format: DURATION
          type: MEASURE
          value:
            mode: FORMULA
            formula: >-
              median(
                if(
                  process(
                    countIf("event_log"."event_name" = 'Opening') > 0 and countIf("event_log"."event_name" = 'Closing') > 0, "case_table"."incident_id"
                  ),
                  process(
                    date_diff(
                      second,
                      minIf("event_log"."event_time", "event_log"."event_name" = 'Opening'),
                      maxIf("event_log"."event_time", "event_log"."event_name" = 'Closing')
                    ),
                    "case_table"."incident_id"
                  ), 0
                )
              )
          formatting: AUTO
          displaySign: DIAGRAM
          color:
            mode: AUTO
      textSize: 12
      showMarkdown: false
      ignoreFilters: false
      markdownMeasures: []
      filters: []
      titleSize: 14
      title: ""
      filterMode: DEFAULT
      titleColor:
        mode: AUTO
      stateName: null
      markdownText: ""
      sorting:
        - name: Quantity
          value:
            mode: IN_WIDGET
            index: 1
            group: dimensionsAndMeasures
          direction: DESC
      showTotal: false
      actions: []
      titleWeight: NORMAL
      rowsLimit: 150