​
Data Configuration

​
Columns Included

This section lists the columns that are displayed in the table. By default, all columns will intially be included in the data table. Click on the X to the right of the column to exclude it. This column will now appear in the section below, Columns Excluded.

In this section, you can also specify certains columns to be initially hidden, but allow end users to be able to unhide these. To do this, enable the Editing Columns section in the Format Tab, and then in the Data Tab, click on the Eye icon for columns that you wish to hide initially.

​
Columns Excluded

This section lists the columns that are not displayed in the table. By default, this section will be empty. Click on the + icon to the right of columns that have been excluded to add them back to the table.

​
Filter

This section is for filtering the chart based on certain columns. You can read about chart filtering here.

​
Formatting

  • Title: This text will appear at the top of the table.
  • Filtering: This specifies if end users will be able to filter the table. If turned on, a filter icon will appear at the far right of the header. End users can configure the filte by specifying a column, operator, and value.
  • Editing Columns: This specifies if end users have the ability to select and deselect columns they wish to see in the data table, as well as reorder columns. If toggled on, a gear icon will appear at the right corner of the header. End users can then select and deselect columns and drag to reorder them.
  • Descriptive Tooltip: This tooltip will appear to the right of the title.
  • Url Link: Read about this section here.
  • This includes the total number of results and pagination information.

​
Styling

Columns

  • Column lines: This specifies if the table should have lines separating columns. By default, this is turned off.
  • Bold column headers: This specifies if the column headers should be bolded.
  • Bold first column: This specifies if the values in the first column should be bolded.
  • Freeze first column: This specifies if the first column should always be visible if the table scrolls horizontally. If toggled on, the first column will remain in the same spot when scrolling.

Rows

  • Row lines: This specifies if the table should have lines separating rows. By default, this is turned on.
  • Row height: This specifies a pixel height for each row. The minimum row height is 30. If cell text is wrapped, the row height will only impact the header row.
  • Rows per page: This controls how many rows are loaded each time a user pages through the table. By default, this value is 50.
  • Group rows visually by first column: This will group the data by the values in the first column, and then display each group in a section on the table. If this is turned on, sorting and column editing will be disabled.

​
Layout

  • Column Fit: “Fill” automatically adjusts column widths to fill the table and columns cannot be resized. “Fit cell” automatically adjusts columns to fit the body cell content so that all the cells’ content are visible. Columns can be resized. “Fit cell” and “Fit cell and header” automatically adjusts columns to fit the header and body cell content. Columns can be resized. If you would like to manually resize columns, you cannot use “Fill”. “Fit cell” and “Fit cell and header” may only be used when “Wrap text” is turned off.
  • Wrap text: Wraps text onto multiple lines if the text is too long for the cell. If turned on, “Column Fit” may only be set to “Fill”. Warning: The Data Table is not optimized for wrapping text. Some features may not work as intended when on. It is strongly recommended to use a fixed row height when on. Applies to header and body cells.
  • Custom Column Widths: Overrides column widths. Works with any “Column Fit” and “Wrap text” setting.

​
Column Formatting

  • Ignore invalid dates: If you didn’t want invalid dates to show up as “Invalid dates”.
  • Sorting: This specifies if sorting is allowed on the table. By default, this is turned on.
  • Sort descending first when clicked
  • Initial Column Sort: If sorting is turned on, you can specify an intial column and sort order.

Columns

  • This section allows for formatting each individual column. The formatting options will depend on the type of the column
    • Column Heading: This text will appear as as the column header. By default, this is the name of the column from the dataset. This can be edited to make the table more readable.
  • Tooltip: This text will appear to the right of the column header.
  • Format: Read more about all value formatting options here.
  • Alignment: This specifies horizontal alignment for the column. Default alignments are dependent on the column type.

​
No Data Configuration

Read about the No Data Configuration section here.

​
Actions Tab

​
Heading Actions

Export

  • Format
  • Download file name: This specifies the name of the downloaded file. The default is the data panel name.

Other

  • Link to a URL

​
Chart interactions

  • Drilldown: See more info here
  • Row Level Actions: See more info here