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:
-
Select Data in the top navigation bar, and choose Tables, Worksheets, or Views.
-
Select the name of your data source.
-
On the Columns tab, find the COLUMN NAMES you want to exclude from SpotIQ analyses, and scroll to the right to find
SPOTIQ PREFERENCE. -
Use the dropdown menu to set the
SPOTIQ PREFERENCEto EXCLUDE for each column you want to exclude. -
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.
-
Select Data in the top menu, and choose Tables, Worksheets, or Views.
-
Select the name of your data source.
-
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. -
Use the dropdown menu to set the
SPOTIQ PREFERENCEto DEFAULT for each column you want to include. -
Select SAVE CHANGES in the upper right.
Related information
