ThoughtSpot Software Documentation

December 2024 10.1.0.sw

In this release, you can try our redesigned and customizable homepage, where you can ask natural-language questions with Sage, view your watchlist, favorites, library of Answers and Liveboards, and more. With the new left-hand navigation, you can go directly to your Liveboards, Answers, SpotIQ Analysis, and Monitor Subscriptions.

This new homepage experience is disabled by default. Contact your ThoughtSpot administrator to enable this feature for your cluster. After that, open your user profile, and in the Experience section, set the Navigation and Homepage to New experience. Note that this setting also enables persona-based navigation. For more information, see New homepage.

In this release, you can try our completely redesigned navigation experience organized by persona. The new app switcher allows business users, analysts, data engineers, administrators, and developers to work in separate contextual sections designed specifically for their needs. In addition, each app has left-hand navigation to create better consistency and ease of use for users switching between the different apps.

This new navigation experience is disabled by default. Contact your ThoughtSpot administrator to enable this feature for your cluster. After that, open your user profile, and in the Experience section, set the Navigation and Homepage to New experience. Note that this setting also enables the redesigned homepage. For more information, see Persona-based navigation.

You can now choose how null and missing values appear in line, column, and bar charts in ThoughtSpot. Null and missing values appear as bars of 1 pixel width on bar and column charts. You can choose whether to display null date values as zero values, line breaks, or an average of proximate values on a line chart. Rather than showing a sharp decline to zero every time there is null or missing data on your line chart, you can see the missing values represented as line breaks or averages of the closest values instead.

For more information, see Null and missing values in charts.

Semi-additive measures with first and last values are now available to all users and on by default. A semi-additive measure, also known as snapshot data, is a measure that is usually aggregated for all attributes except for date and time. For certain measures, like inventory, you want to know what the value was at the beginning or end of a period. In that case, you can use the last_value function to find the inventory at the end of a month, rather than aggregating all values over the month. Similarly, you can use the first_value function to find out your stock at the beginning of a month.

For more information, see Semi-additive measures with first_value and last_value functions and Modeling data for semi-additive measures.

The "of" and "percentage of" keywords are now on by default and available to all users. You can use the "of" and "percentage of" keywords to answer questions related to mix, contribution, share of, percentage, and total ratios. These keywords help answer questions such as, "What is the share of a certain store’s sales as a percentage of the regional whole?" To try out this feature, enter a search phrase in the search bar containing the keyword, such as sales percentage of store region, and press Go.

For more information, see Keywords: Of and Percentage of.

Drill down in change analysis is now on by default and available to all users. You can now drill down on specific columns in change analysis, in order to identify change drivers within your data. For example, if you run an analysis on sales monthly and find out that the 'jacket' item type changed the most, you can easily drill down on jacket sales and identify which region contributed the most to the change in sales.

For more information, see Iterative change analysis.

ThoughtSpot introduces support for scheduling Liveboards with Excel (XLSX) attachments, in addition to the existing PDF and CSV options. This allows users to explore tabular data from these reports by using the XLSX data files. For more information, see Schedule a Liveboard job.

You can now change the filter values on Liveboards that have visualizations that include hidden columns, or a formula created from a hidden column. Liveboard filters are now accessible to all users who have view or edit permissions to the underlying data source.

For more information, see Liveboard filters.

You can now rename columns in an Answer and see the new name reflected on the table header, tooltips, legend, and chart configuration menu. Changes made to an Answer are not reflected in the underlying Worksheet. For more information, see Rename a table column.

Personalized columns are now available to all users and on by default. Users with edit permissions on a Liveboard can set their preferred attribute columns through the change analysis window and select Apply to all users to keep those selections for any subsequent change analysis calculations on that Liveboard. Individual users can still override these preferences for their own calculations.

For more information, see Remember personalized columns.

ThoughtSpot introduces the ability to customize note tiles. You can now customize the appearance of note tiles. You can also edit hyperlinks and iFrames that previously had to be deleted and replaced to make changes. Images within note tiles are now responsive to screen size. For more information, see Liveboard note tiles.

You can create sets, which can be used to classify values in a list that you can then reuse across multiple analyses. Sets can be query sets or column sets. A query set is a custom group of values from a collection of objects in your database. A column set is a custom group of values from a single column. Sets are community objects which remain when you navigate away from the Search Data page and can be used by any user with view access to the underlying Worksheet. To enable this feature, contact ThoughtSpot Support. For more information, see Query sets and Column sets.

You can now use TML to import and export column sets and query sets in ThoughtSpot. For more information, see TML for Sets.

ThoughtSpot introduces the ability to save table layouts in the schema viewer. Table location and size are now maintained and saved in the schema viewer. For more information, see How to view a data schema.

ThoughtSpot now supports grouping measures in pivot tables. You can now move measures, and position them where you want in rows and columns. For more information, see Pivot tables.

ThoughtSpot introduces custom sorting of attributes to sort all chart types in a way that helps users to consume charts more efficiently. Previously custom sorting could only be applied to an Answer using custom columns and the search bar, and could not be applied to some chart types. You can now sort on any column in a chart, in ascending or descending order, from the column heading menu. To enable this feature, contact your administrator. For more information, see Define a custom sort order for a Worksheet.

ThoughtSpot now supports Korean and we’ve also added synonyms for date and time based keywords in German and French for a more accurate experience.

You can now use custom charts created outside of ThoughtSpot, including third-party chart libraries. To enable this feature, contact ThoughtSpot Support. For more information, see Custom charts.

Introducing Models. Models are an easier way of creating what previously were called Worksheets. You can create Models from the Data tab, just like Worksheets. You can still create and use Worksheets, but ThoughtSpot plans to deprecate and remove Worksheets in a future release. For more information, see Models.

Version control for Liveboards and Answers is available to all users. Now teams of analysts can more easily collaborate on content development of Liveboards and Answers. You can enable version control on specific Liveboards and Answers. With version control enabled, every time you save the Liveboard or Answer, a new version is created and stored. You can browse the version history in ThoughtSpot and restore any saved versions whenever you need to. To enable this feature, contact your administrator. For more information, see Liveboards and Answers.

ThoughtSpot now supports the ts_groups system variable in Answer and Worksheet formulas. You can use the ts_groups variable for data masking, or deciding whether to display the value of a column to a user based on their group membership. For more information, see Data masking with system variables.

We now support OAuth with PKCE for Starburst.

ThoughtSpot now supports secondary role configuration when you create a Snowflake connection using External OAuth. When you set secondary roles to ALL, you can access all tables that any single role has access to and combine them in a single SQL query without having to switch roles.

For more information on primary and secondary roles, see Enforcement model with primary role and secondary roles and Add a Snowflake connection.

You can now use the table TML file to make changes to connection details like remapping columns and changing data type, rather than using the connection.yaml file. This allows you to make small changes to a Connection without the need to resolve all possible errors first. You can also edit or export the Connection TML file from the Data workspace. For more information, see TML for connections.

ThoughtSpot introduces a consistent sort order when exporting the TML of an object (table, SQL view, Liveboard, etc.). This ensures that unnecessary differences don’t show up between TML files when the objects haven’t really changed, and makes it easier to compare TML files.

You can now select a dbt connection and click Share to share the connection with other users or groups. By default, the underlying Cloud data warehouse connection is shared. Note that you need Can manage data privileges to access and share dbt connections. For more information, see Share a dbt connection.

When creating a Worksheet from a dbt connection, ThoughtSpot joins the tables based on the relationships defined in the underlying .yml schema file. Now, joins between the tables will be created local to the Worksheet instead of creating a global join between the tables.

ThoughtSpot displays dbt error messages that clearly describe whether the error originated in dbt or in ThoughtSpot, where the error was encountered, and what steps users should take to resolve the issue. For a list of the error messages ThoughtSpot supports, see dbt error messages.

ThoughtSpot now supports dbt version 1.7.

Now in the new Answer data panel, you can filter as you hover on a column, By category grouping by default, and display the information panel when you click a column.

Administrators can now enable version control of Liveboards and Answers. You enable version control for your ThoughtSpot Org by connecting it to a Github repository. Once enabled for the Org, version control can be enabled individually for any Liveboard or Answer. Each time a user saves changes, a new version of the Liveboard or Answer is created and stored in your Github repository. Users can easily browse and restore an older version from the Liveboard or Answer itself. For more information, see Version control for Liveboards and Answers.

You can now create multiple configurations for each Snowflake connection. This allows you to allocate a separate Snowflake warehouse for different ThoughtSpot users or groups, eliminating the need to duplicate Liveboards and configure multiple Snowflake connections and helping you with cost tracking and chargeback. You can also use this for your search indexing so that you can control and balance the computing load. In addition, this allows you to easily test a set of Liveboards against different environments (dev, qa, prod), and configure different databases for multi-tenancy / multi-org deployments. For more information, see additional configurations for your Snowflake connection.

Customers licensed to embed ThoughtSpot can use ThoughtSpot Embedded features and the Visual Embed SDK.

To enable ThoughtSpot Embedded on your cluster, contact ThoughtSpot Support.

For new features and enhancements introduced in this release for ThoughtSpot Embedded, see ThoughtSpot Developer Documentation.