Skip to main content

 

ThoughtSpot

Set the Format to Use When Showing Numbers

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

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.

You can use any of the supported number formats for delimiters and number of digits to show using Java Decimal Notation. Currency symbols are not supported.
The default values are:
  • #,### for integer data types (INT, BIGINT).
  • #,###.00 for decimal data types (DOUBLE and FLOAT).
These are some examples of formats you can use:
Table 1. Number Format Examples
Stored Value Format Pattern Display Value
12345.6789 #,##0.## 12,345.68
12345.6789 #,##0.### 12,345.68
12345.6789 #,##0.00000 12,345.68
12345.6789 #,##0 12,345
12345.6789 #,##0.00 12,345.68
12345 #,##0.## 12,345
12345 #,##0.00 12,345.00

To change the date format used to display a column's values:

  1. Find the Format Pattern for the column whose display format you want to change.
  2. Change it to the format you want to use.
  3. Save your changes.