Only applies to tables that join over a Chasm Trap. Designates whether the tables depend on this column for attribution.
Data modeling for worksheets
For worksheets, only some of the settings can be modified, whether you are using the modeling file or the Web interface. The editable settings for worksheets are:
If you want to change any of the settings that cannot be modified in a worksheet, you need to make your changes to the underlying table instead, and they will be reflected in all worksheets that use the table.
Change the column name
You can change the text that is shown for the column names in ThoughtSpot to make the names more meaningful to users. The column name is what they will type to add that column to their search.
Add a column description
You can provide a description for a specific column, to provide additional information for users about the data it contains.
Change the additive setting for a column
Your data may contain a column with a numeric data type that you have defined as an ATTRIBUTE rather than a MEASURE (such as age). You can allow aggregations on the values by changing the value of the Additive setting.
Change the aggregation setting for a column
All types of aggregations can be performed on MEASURE columns, and some aggregations can be done on ATTRIBUTE columns. You can change the default aggregation type to make combining data more intuitive and faster.
Hide a column
You can hide columns from users in ThoughtSpot without dropping them from the database. This is common when the data contains identifier columns that are used to join tables, but which do not have any meaning to users.
Create synonyms for a column
If you want to allow searching using more than one name for a column, you can create synonyms for it. This is helpful when different departments refer to the data using different terminology, for example.
Change the index type for a column ThoughtSpot indexes column names and unique column values. The indexes are used to dynamically generate suggestions in the search bar when typing a search.
Set the format to use when showing numbers
You can set a format for how numbers are displayed in tables and charts. For example, you can display numbers with a different number of digits after the decimal point, based on the data modeling setting Format Pattern.
Set the format to use when showing dates
You can set a format for how dates are displayed in tables and charts. For example, you can display dates in a standard European or US format based on the data modeling setting Format Pattern.
Set the format to use when showing currencies
You can set a format for how currencies are displayed in tables and charts when using the ThoughtSpot Data API or Embedding. For example, you can display currencies in a standard European Euro or US Dollar format based on the data modeling settingCurrency Type.