Formatting metric data

Customize the display of numbers in tables and charts by defining their format. This feature allows you to adjust decimal places based on your data modeling preferences, offering various supported number formats, including delimiters.

For integer data types like INT and BIGINT, use #,###, which only accepts numerical values without alpha characters. For decimal data types such as DOUBLE and FLOAT, use #,###.00, supporting numerical values up to two decimal places.

These are some examples of formats you can use:

You can apply number formatting in ThoughtSpot in two ways:

Using Data Options

• Select the worksheet where you want to apply number formatting.

• Open the worksheet and locate the column named “Format Pattern.”

• Enter the desired format pattern to modify measures and save the changes.

During Answer Creation

• From the search tab, create an answer using attributes and measures in table format.

• Apply number formatting to measures.

• Clicking on any metric formatting option on the right-hand side opens the ‘Edit Chart Configuration’ settings. Here, you can adjust the number formatting settings for your data.

Number formatting

You can format the numbers in any table column based on a measure.This functionality allows you to change the category (number, percentage, or currency), units (auto, none, thousand, million, billion, or trillion), or method of writing negative values (-1234, 1234-, or (1234)).

To change the number formatting:

You can reach the Edit panel from the more icon that appears when you hover over a column name:

1. Under number formatting, you can edit the category, units, or method of writing negative values. Open the dropdown menus to select new values.

Example

To display the measure in thousands with one decimal point, select 'Thousand' as the unit and set 'Decimals' to 1. The screenshot below shows the result after applying these changes."

Now Apply any Vitara Chart ,example Vitara Column Chart

By default ,Vitara charts will display data labels in its own format i.e. short format. If we want to the values in this format we have to enable the use metric formatting option from data labels tab and Axes tab

Below is the screenshot of the Vitara Column Chart after enabling 'Use Metric Formatting'. The applied formatting is now visible in the data labels, tooltip, and axes.

Note: When the 'Use Metric Formatting' option is enabled in the Data Labels menu, the tooltip will also display values in the same format as the data labels

Applying Currency Formatting in ThoughtSpot

You can apply currency formatting in ThoughtSpot through two methods:

1. Using Data Options (Data Level)

• Navigate to the Data tab and select the worksheet where you want to apply the currency format.

• Open the worksheet and locate the desired column.

• In the "Currency" field, Choose the appropriate currency symbol or code (e.g., $, €, ₹) based on your requirement .

• Save the changes to apply the currency format at the data level. This approach ensures consistent currency formatting across all answers using this worksheet.

2. During Answer Creation (Chart Level)

• Go to the Search tab and create an answer using attributes and measures, Select the metric (measure) to which you want to apply currency formatting.

• In the configuration options, navigate to Number Format → Currency, and choose the desired currency symbol or format. This method is useful when you want to customize currency formatting for specific answers or visualizations.

Please refer to the Data Label Customization section for detailed steps.

Percentage Formatting's

When a metric is formatted as a percentage, VitaraCharts automatically displays the data as percentage values. Any aggregations applied through the chart menus will honor this formatting. All relevant chart elements—such as data labels, axis labels, totals, and tooltips—will consistently display values in the correct percentage format.

Now, apply any Vitara chart—for example, the Vitara Column Chart—to visualize the data with the specified percentage formatting