Set columns to exclude from SpotIQ analyses

SpotIQ is a ThoughtSpot feature that provides users with insights about their data by automatically surfacing interesting characteristics (trends, correlations, outliers, and so on).

If you have access to tables, Worksheets, and views for data modeling purposes, you can specify columns to exclude from SpotIQ analyses. By default, all columns are included in SpotIQ analyses.

Exclude columns from SpotIQ analyses

To specify columns to exclude from SpotIQ analyses:

  1. Select Data in the top navigation bar, and choose Tables, Worksheets, or Views.

  2. Select the name of your data source.

  3. On the Columns tab, find the COLUMN NAMES you want to exclude from SpotIQ analyses, and scroll to the right to find SPOTIQ PREFERENCE.

  4. Use the dropdown menu to set the SPOTIQ PREFERENCE to EXCLUDE for each column you want to exclude.

  5. Select SAVE CHANGES in the upper right.

Include columns in SpotIQ analyses

By default, all columns are included in SpotIQ analyses.

If you have previously set some columns to EXCLUDE and you want to re-set these to be included, do the following.

  1. Select Data in the top menu, and choose Tables, Worksheets, or Views.

  2. Select the name of your data source.

  3. On the Columns tab, find the COLUMN NAMES you want to set back to include in SpotIQ analyses, and scroll to the right to find SPOTIQ PREFERENCE.

  4. Use the dropdown menu to set the SPOTIQ PREFERENCE to DEFAULT for each column you want to include.

  5. Select SAVE CHANGES in the upper right.