/ Release Notes Version 3.1


Release Notes Version 3.1

Release 3.1

Release Date: October 2015

The ThoughtSpot 3.1 release includes features focused around support for complex schemas, conditional formatting, grouping formulas, and user experience improvements.

What’s New in this Release?

Conditional Formatting

You can now use Conditional Formatting to show target metrics in relation to your data. Does your company have KPIs (Key Performance Indicators) or threshold metrics you want to visualize along with your data? Now you can add visual cues for these metrics to charts and tables, so you can easily see where you are falling short or exceeding targets.

Conditional Formatting in charts

When viewing a chart select Conditional Formatting.



Figure 1: Choose Conditional Formatting


Set rules to define one or more sets of values in your data. Then set a color to use for each set of values in charts.



Figure 2: Set a Conditional Formatting threshold


The chart will show the threshold(s) you defined, and the data that falls within them will be shown using the same color.


Figure 3: Chart with Conditional Formatting

Conditional Formatting in tables

You can also add Conditional Formatting to set the background color of cells in a table based on the values they contain. To do this, choose Conditional Formatting from the column header. Define the sets of values and the color to use for each set.


conditional formatting table1.png

Figure 4: Set Conditional Formatting color for a table


The cells that contain data in the range(s) you set will have the same background color.


conditional formatting table2.png

Figure 5: Table with Conditional Formatting

Formulas in Answers

You can now add a formula directly to your answer. When you’re doing a search, click the Add Formula icon.



Figure 6: The Add Formula icon


Then use the Formula Builder to build your formula. Formulas elements are color coded by type and can include the formula operators and functions, the names of columns, and/or constants.



Figure 7: Creating a formula


To see all the operators and functions you can use to build formulas, click on Formula Assistant.



Figure 8: The Formula Assistant

Grouping Formulas

You can easily group aggregations using a new set of grouping formulas. Use grouping formulas to show things like average revenue by department or sum of retail sales by city, state, or country. In the last release, you had to use Query-on-Query to create this type of aggregation. Now it’s much easier and faster to do using a grouping formula.

The grouping formulas introduced with this release are:

  • group_average( )
  • group_count( )
  • group_max( )
  • group_min( )
  • group_stddev( )
  • group sum( )
  • group_variance( )

These formulas accept a measure to be aggregated, and one or more attributes by which to group. The new grouping formulas use this syntax:

group_ (, ,...n>)


Figure 9: Create a grouping formula


Figure 10: Grouping formula result in a table

Time data in user uploads

Data that you upload through the ThoughtSpot application can now have time-only fields. In past releases, only date and date/time fields were accepted. The new supported time formats are:





hh:mm a

10:32 AM



hh:mm:ss a

10:32:22 AM


10:32:22.0, 10:32:22.000

hh:mm:ss.SSS a

10:32:22.0 AM, 10:32:22.000 AM

Custom Quarter/Fiscal Year

You can now customize when the year begins in ThoughtSpot to reflect your fiscal year. When you set a custom fiscal year, quarters will correspond to your setting in existing and new answers, pinboards, and data sources.



Figure 11: Custom fiscal year/quarter

Set a Date Format

There is a new setting in the modeling file and in the new data modeling screen. Date Format allows you to set a format to use when showing the data in a date column. You can use any of the formats that are supported for User Data Import. The complete list of formats supported is quite extensive, and is included in the Date and Time Format Reference in the ThoughtSpot Administrator Guide.

Some of the most commonly used formats are:

  • MM/dd/yyyy
  • DD/mm/yyyy
  • MM/dd/yyyy HH:mm
  • DD/mm/yyyy HH:mm


Figure 12: Set the Date Format

Chasm Trap

You can now join tables across a chasm trap. The addition of support for chasm traps allows ThoughtSpot to work with very complex schemas.


Figure 13: Chasm trap schema diagram

A chasm trap occurs when two unrelated fact tables share a dimension table. You can join them through the shared dimension table, but if there is no support for chasm traps, this can produce a cartesian product that leads to overcounting.

With the introduction of the chasm trap feature, you can now join tables in this type of schema, and obtain accurate answers. In prior versions, this type of search was blocked because of the danger of overcounting and producing a misleading answer.

You can now perform searches across a chasm trap, with protection from overcounting when computing counts and aggregates. The tables must be joined via an equijoin (not via a range). As part of the support for chasm traps, there is a new data modeling setting called Attribution Dimension. If your schema includes chasm traps, you should review this setting in the ThoughtSpot Administrator Guide.

Very Large Text Columns Support

The 64K limit on text fields stored in VARCHAR columns has increased to 1GB. This allows you to store wide text columns, such as customer comments, call center transcripts, and long documents. To give you an idea of how much text 1GB is, you could store the entire Lord of the Rings trilogy about 150 times over in 1GB of space, depending on how it’s encoded, of course.

Enable/Disable SSL

You can now enable or disable SSL for ThoughtSpot. If you disable SSL, users won’t get a browser security warning when they access ThoughtSpot on a cluster for which you’ve not installed an SSL certificate. If you decide to install a certificate at a later time, you can turn SSL back on. The commands to enable/disable SSL are:

$ tscli ssl on

$ tscli ssl off

Installed Package Viewer

You can now see a list of packages installed on the appliance, along with their versions. Use these tscli commands:

tscli os find-package <package_name>

Lists all packages and versions included in the product image whose name contains <package_name>.

tscli os list-packages

Lists all packages and versions included in the product image.

UX Improvements

Data Management Improvements

Data sources include tables, worksheets, and user imported data. The user experience has been improved for viewing and modifying data sources. The filtering and navigation now appear at the top of the data source listing. You can access the properties, view sample data, view and change relationships (links between data sources) by clicking on the name of a data source.


Figure 14: The Data Management screen

Column Properties Changer

You can now make quick modeling changes from the Columns page for a data source without having to download the modeling file. This reduces the potential for errors and lets you easily see the settings for an individual data source. You no longer need to remember which values are valid for GeoMaps or aggregation types, because these are presented as a dropdown list in the user interface.


Figure 15: Data modeling in the Columns screen

The classic modeling file download/upload is still available for making bulk changes.

Headlines in Pinboards

You can now pin a headline to a pinboard. This allows you to feature prominent data in your pinboards and presentations.


Figure 16: Headline in a Pinboard

Download a Table as a PDF

You can now download a table to a PDF. This allows you to save a snapshot of the table or easily add it to a document or report.

Choose only one item from a legend

When viewing a chart, you can now choose to see only one of the items by finding it in the legend and choosing Show Only. In the past, you had to uncheck all the other items from the legend.


Figure 18: Filter a legend to only see one value

What’s Changed in this Release?

Default Email for Alerts

In past versions, the default email to receive ThoughtSpot cluster alerts was prod-alerts@thoughtspot.com. This has changed to default to blank, so that no emails are sent unless you configure the email to receive them either during installation or by issuing:

$ tscli support set-mailname

Views Will be Deprecated

The workflow for Query-on-Query searches has been streamlined. Views are no longer necessary. If you want to do a search on top of another search, you can save your answer as a Worksheet. You can still link the Worksheet to other sources and search it, as you could do with Views.

If you’ve created searches using Views on a prior release, they will still work in release 3.1. But in a future release, when Views are deprecated, you will need to recreate them as Worksheets instead.

What’s Fixed in this Release?

FIXED: Stacked area chart legend details are incorrect


Description: When hovering over a stacked area chart, the information given in the details popup is inaccurate. For example, instead of showing the actual numeric value and the percentage of the whole, an incorrect percentage is shown.

FIXED: Latitude and Longitude must be stored as varchar (text) to work with GeoMaps


Description: In release 3.0, latitude and longitude columns had to be stored as varchar (text) to be recognized as geographical data. Now latitude and longitude can be viewed as GeoMap charts when stored as double (number).

FIXED: Security Updates

ISSUE ID: SCAL-10902, 10903

The following Security Common Vulnerabilities and Exposures have been addressed in this release:




OpenSSL vulnerabilities in openssl and libssl


OpenSSL vulnerabilities in openssl and libssl


OpenSSL vulnerabilities in openssl and libssl


OpenSSL vulnerabilities in openssl and libssl


OpenSSL vulnerabilities in openssl and libssl


OpenSSL vulnerabilities in openssl and libssl

CVE-2014-0076 OpenSSL vulnerabilities in openssl and libssl
CVE-2014-3566 Nginx SSL vulnerabilities
CVE-2013-4547 Nginx Request Line Parsing Vulnerability

Known Issues

Save Button becomes enabled, but nothing has changed


Description: In the Data Management screen for Columns settings, if you click on a value that is not editable, the Save button becomes enabled. It should remain disabled, since nothing has been changed.

Adding a filter on top of a formula in a chasm trap worksheet fails


Description: When adding a filter on a formula column that was added to a worksheet which spans a chasm trap, an error is returned.

Adding a formula to a worksheet changes the join type


Description: When creating a worksheet with the join type set to left outer join, the join type changed to an inner join again after adding a formula. As a workaround, before adding a formula to a worksheet, you should check the join type. You can do this by selecting Choose Sources when in edit mode. After adding the formula, if the join type has changed, edit the worksheet, select Choose Source and change the join type back to the original setting.

Supported Upgrade Paths

If you are running a release that begins with one of the following ThoughtSpot version numbers, you can upgrade to this release directly:

  • 3.0

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