Explo home pagelight logo
All Charts
Data Table

​
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.
  • Show export button: This specifies if the export button appears in the bottom right corner of the footer.
  • Download file name: This specifies the name of the downloaded file. The default is the data panel name.
  • Enable download export: This specifies if the table is downloadable via both CSV and XLSX.
  • Enable email report: This specifies if the end user can email either a CSV or an XLSX file of the data.

​
PDF Download

  • Header: This specifies if the PDF download exported from the data table should have a header. If toggled on, you can specify an image (via url) or text for each of the following sections of the header:
    • Left
    • Center
    • Right

​
CSV Download

  • Tab Delimited: This specifies if the CSV download exported from the data table should have values separated by tabs. If not turned on, the separators will be commas.

​
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.

​
Cells

  • Wrap text: This specifies if text within a cell should wrap, increasing the height of the row. By default, this is turned on.

​
Columns

  • Sorting: This specifies if sorting is allowed on the table. By default, this is turned on.
  • Initial Column Sort: If sorting is turned on, you can specify an intial column and sort order.
  • Column Formatting: 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.
  • Join: This sections allows you to replace one column in the table with a column in a different dataset. If turned on, specify the dataset that contains the new column, as well as the column to join on and the column that should be displayed in the table.
  • 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.

​
Drilldown

Read about the Drilldown section here.

​
No Data Configuration

Read about the No Data Configuration section here.