Estimated reading time: 8 minutes

What’s in the Release Notes

ThoughtSpot version 5.1.2 is now available. These release notes include information about new features, fixed issues from the previous releases, and any known issues.

Supported Upgrade Paths

If you are running one of the following versions, you can upgrade to the 5.1.2 release directly:

  • 4.5.1.x to 5.1.2
  • 5.1.x to 5.1.2

(This includes any hotfixes or customer patches on these branches.)

If you are running a different version, you must do a multiple pass upgrade. First, upgrade to one of the above versions, and then to the 5.1.2 release.

5.1.2 Fixed Issues

Search no longer stops working under certain conditions like fast typing, or copying and pasting of a search query.

Selecting ‘Copy and Edit’ in an answer, pinboard visualization, insight, SpotIQ pinboard or view, no longer causes the user to be signed out.

HDFS images for a cluster are now created prior to pushing the HDFS configuration. This ensures images are fresh during an upgrade.

When removing a node, the node calling command no longer results in unreachability due to misconfigured firewall settings.

Permissions issues with tsload and tql are now fixed, so the thoughspot user can load data.

Database stability has been improved.

5.1.1 New Features and Functionality

Data visualization color refinements

Visualization colors have been refined to match ThoughtSpot’s fresh, new look. You can still customize colors, and reset them to the default color palette later, if needed.

5.1.1 Fixed Issues

Geo Bubble map labels can now be disabled or enabled through a data labels checkbox.

Filter panel failure to open during formula creation has been fixed.

Custom R analysis failure when run from Custom Analyze has been fixed.

Microsoft Internet Explorer button display problem in Edit Group, Add a New Group, and Custom Analysis has been fixed.

Tooltips in line, scatter, and radar charts have been improved to avoid tooltip display when far from a data point.

Microsoft Internet Explorer problem with saving the name of an answer has been fixed.

Previously, admin style and font customizations for tables and charts were off by default. They are now on by default.

Search phrase autocomplete has been fixed to prevent unnecessary red highlighting of values.

Geo Bubble and Geo Heatmap issue where chart displays momentarily and then disappears has been fixed.

Zoom on Geo maps can now be done using a mouse scroll wheel.

5.1 New Features and Functionality

Quick Select

When you type a phrase or a letter in the search bar, the first suggestion is automatically highlighted and you can press Enter to select it (Quick Select). Suggestions can be an attribute, measures, value, keyword, historical queries, or exactly what you typed as the search phrase. Historic suggestions always display on top with the first suggestion highlighted as default. If there are no suggestions, the suggestion list is not be displayed.

Improvements in the presentation mode experience of pinboards

When you display pinboards charts on projectors in conference rooms and on a laptop that has a widescreen display, the display automatically adjusts itself depending on the size of the display screen. For example, if you are using a widescreen display, pinboard font size increases for a more definitive and high-quality experience.

  1. Choose a pinboard that you want to display and click the present icon present icon (top-right).

    Alternatively, you can click the ellipses more options menu icon and select Present.

  2. Use the Up and Down arrow keys to navigate.

Stable search suggestions

Search suggestions are now more stable. When you start to type a search phrase and the full matching phrase appears in the results list, the order in which it appears does not change as you finish typing it.

Show rounded or non-rounded numbers on charts

You can set labels on charts to show rounded or non-rounded numbers.

Pie charts now support color customization

You can now customize the colors of each slice on pie charts from the chart Styles panel. Click the Styles button next to any pie chart to get started (paintbrush icon).

Longer pinboard descriptions

Table or chart descriptions in a pinboard can now be up to two lines long. Descriptions that exceed a second line are truncated with three periods (…) at the end. Headline tiles (which don’t have a table or chart) are limited to a one-line description.

New typography in the desktop app

With the 5.1 release, the fonts used are Optimo Plain and BB Roller Mono. This provides a modern, more readable look for the ThoughtSpot application user interface and data visualizations.

Table aggregate headline

The Table Aggregate headline option is available when an aggregate function is used in a table either through a formula or a search bar query, like the average of a measure. It recalculates the function for the entire table. In such cases, the Table Aggregate is shown by default below the table, instead of the “Avg” option, which does a second level of aggregation on top of the existing aggregation.

Period to date

Before 5.1, Period to Date didn’t work in conjunction with other date filters. With this release, you can compare data spread across the same period and drill down to a specific period of a year, month, week, and date.

For example, you can compare:

  • quarter to date vs last year quarter to date
  • month to date vs last month to date
  • year to date vs last year month to date
  • week to date vs last quarter week to date

To review date keywords, see Date in keywords reference.

For more about vs keyword, see Comparative in keywords reference

Case sensitivity on formulas is supported

You can now enable case sensitivity when defining formulas, and the final formula output retains the case sensitive state. Quoted text in a formula can now be case-sensitive. For example, “if revenue > 1000 then 'Good' else 'Bad'”. The output of this formula retains the case.

SpotIQ personalization

Users can specify “Insight Threshold Settings” as part of their individual profile SpotIQ preferences to further refine the parameters SpotIQ uses. SpotIQ profile preferences are a subset of those available on the SpotIQ “Customize analysis dialog”, and persist for all SpotIQ analyses, unless you explicitly reset options for custom analyze.

Improved search editing

You can edit a search without affecting existing search results. You can insert a new phrase or edit an existing one in the middle of a search without causing any errors. You can even merge words or phrases without breaking the search. As you edit your search, ThoughtSpot continuously generates new results.

Copy and edit

The previous feature called “Make a Copy” is now called “Copy and Edit” and it brings a major workflow improvement. Instead of simply saving a copy in the background, “Copy and Edit” allows you to make a copy of an answer, pinboard visualization, insight, SpotIQ pinboard or view and immediately start editing it.

SpotIQ insight feedback

Administrators can save user feedback and use it to suppress down-voted insights from auto or custom SpotIQ analyses.

SpotIQ column level data modeling

Data modelers and administrators can exclude columns from SpotIQ analyses via a new SPOTIQ PREFERENCE option on the Data tabs for worksheets, tables or views. By default, all columns are included in SpotIQ analyses.

Schema Viewer available to non-admin users

Starting in the 5.1 release, you can grant non-admin users with Can manage data privilege access to Schema Viewer. This enables non-admin users to view data in a schema they have access to.

Active Directory (AD) management for ThoughtSpot nodes

ThoughtSpot supports enabling Active Directory (AD) based access individually on each node where the commands are run. To enable AD access on a cluster, the administrator must run the same commands on each individual node and on any additional nodes added to the cluster.

Keyword support for eight new languages / locales (Beta)

Beta mode internationalization (I18N) keywords support for the following additional locales is available in version 5.1:

  • Español (España)
  • Português (Portugal)
  • Italiano
  • Dansk
  • Suomi
  • Svenska
  • Norsk
  • Nederland

5.1 Fixed Issues

The X and Y axes were previously flipped on bar charts and stacked bar charts. This has been fixed.

Notes from older versions