Negative Sign

Negative Sign Customization in Vitara Charts

In ThoughtSpot, you have the option to display negative metrics/measures in three different formats. This option can be enabled from the number formatting options, primarily used to display negative values in brackets.

Enabling Negative Value Formatting

To enable this option when creating a new answer from the table format:

• Access Number Formatting: Navigate to the number formatting options.

• Adjust Settings: Change the setting for ‘Category’ to ‘Number.’

• Format Negative Values: Specify the format for negative values according to your preference.

Here is a screenshot illustrating this process:

Create a Vitara chart from the TS Table view . Hover your mouse over the Vitara chart. The Edit button will appear on the chart. To open the Vitara charts properties window, click the Edit button. Navigate to the Data Labels menu. There will be a Metric Format drop-down box in the Data Labels menu.

Expand this drop-down box and select the option Use Metric Formatting.

When we choose Use Metric Formatting, the data labels and tooltips in Vitara charts are displayed in the same format as in ThoughtSpot.

This means that if we choose Use Metric Formatting, the sign of negative numbers in Vitara charts will match the sign .

Negative sign customization in the Shortened Format:

Note: Before modifying the negative signs using this method, the Metric Formatting option in the data labels menu must be set to Shortened Format (as shown in the screenshot below).

Vitara charts will display the numbers in the abbreviated format by default. If I wish to show the numbers in a reduced format (Vitara Charts’ default format) and customise the negative sign, I must configure the Vitara Charts’ global.txt file.

Note : " To use this specific customization in your environment, please send a request to the VitaraCharts support team. All customization files are managed in a cloud environment by the support team."

The three instances listed below show how we can customise the Vitara Charts to display a negative sign in a reduced numerical format.

Show the default sign. Show a negative symbol. Show parenthesis. We must configure the global.txt file to meet our needs. The code is highlighted in the screenshot of the global.txt file below.

The global.txt file can be found at the following path. \plugins\VitaraCharts\custom

Notations used for negative sign customization:

    -1 use  default formatting, 
     0 display negative numbers with minus sign, 
     1 display negative numbers in parenthesis.

Fill in the below line of the global.txt file with -1, 0, or 1. “metricNegativeValueFormat=-1”

For example, in the vitara charts, if I want to show negative numbers in the paranthesis must enter a 1 in the global.txt file. “metricNegativeValueFormat=1”

The global.txt file customizations can be used to regulate the negative indications in all VitaraCharts. In contrast, the Use Metric Formatting property in a certain chart’s Data Labels menu is used to control the negative sign in that specific chart in that unique Visualization.