Table widgets in Decision Optimization experiments

Last updated: Feb 29, 2024

You can add tables in the Visualization view to improve the readability of data.

Table widget specifications include columns that follow this syntax:

{
  "name": "Table Cars",
  "type": "Table",
  "property": "Acceleration",
  "label": "Acceleration",
  "type": "Number",
  "visible": true,
  "width": 100,
  "style": {}
}

Table 1. Table widget specifications
Field	Description
`property`	Key property to access data in the specified row.
`type`	Required to have a proper search and filter feature, as numbers are not searched like strings.
`visible`	Allows the display or hiding of any column without completely removing its definition.
`label`	Defines the column headings.
`style`	Allows tables to be styled by adding CSS properties in camel case. For example, if you want to specify the alignment of text in a table, use `textAlign` rather than `text-align`.

You can customize the rendering of tables by using the following elements:

Table 2. Table widget customization
Element	Description
`numbered`	Displays row numbers.
`compact`	Reduces row height.
`columnExpand`	Set `columnExpand` to `true` to expand the column widths to fit into the widget.
`columnShrink`	Set `columnShrink` to `true` to shrink the column widths to fit into the widget.

The search and filtering feature is available in tables. To search content in a table, click the search icon . You can limit your search to a specific column, by adding a prefix to your search as follows"column heading":"search". For example, name:chevrolet. To search values that range from x to y, use 10..20. You can also search values greater than x, for example 10.., and values less than x, for example ..20. For more information about table filtering, see Table search and filtering in a Decision Optimization experiment.