VitaraCharts for ThoughtSpot
  • CHART USER GUIDE
    • Angular Gauge Chart
    • Bar/Column Chart
    • Combination Chart
    • Dumbbell Chart
    • Funnel Chart
    • Grid Chart
    • KPI Animation Chart
    • Line/Area line Chart
    • Pie Chart
    • Polar Charts
    • Slope Chart
    • Sparkline Chart
    • Stacked Column/Bar
    • Tornado Chart
    • Variwide Chart
    • Waffle Chart
    • Add as Filter
    • Allow/Block URLs
    • Auto Scroll
    • Axes
    • Background Images
    • Bar/Column Width
    • Color Picker with Opacity
    • Connect Null Points
    • Custom Markers
    • Data Markers
    • Data label customization
    • Download Answers
    • Error Bars
    • Export to PDF.
    • Formatting metric data
    • Gradient Threshold
    • Gradient Color
    • Legend
    • Negative Sign
    • Pattern Fill
    • Play Animation
    • Plot lines/Reference lines
    • Reset color property
    • Reset font properties
    • Right Click Menu
    • Series using Attribute
    • Small Multiples
    • Smooth Line
    • Tooltip Customization
    • Tooltip Links
  • GRID CHART GUIDE
    • Appearance
    • Auto Size
    • Column Totals
    • Custom markers
    • Custom Editor
    • Filter Data
    • Format/Clear Format
    • Grand Total
    • Pivoting and Row Grouping
    • Horizontal Bars/Pins
    • Manage Scaling Grouping
    • Manage Column Grouping
    • Manage Metric Grouping
    • Pin Column
    • Reset Columns
    • Show/Hide Column
    • Sorting
    • Subtotals
    • Thresholds
    • Tooltip
    • Trend Lines
    • Value Aggregation
  • CUSTOMIZATION GUIDE
    • Custom CSS
    • Custom CSS Samples
    • Custom Color Palette
    • Custom Fonts
    • Condensed Metric Format
    • Grid Custom CSS
  • INSTALL DOCS
    • Production Deployment
    • Trial Deployment
  • FAQ
    • Contact Us
    • FAQS
      • How we can do export to PDF
      • How can we define a custom color palette?
      • How can we define and use a new font?
      • How can customers reach Vitara technical support team?
      • How can I find the version of Vitaracharts installed?
      • Where can I find the chart state information?
Powered by GitBook
On this page
  • Using Data Options
  • During Answer Creation
  1. CHART USER GUIDE

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:

Stored Value
Format Pattern
Display Value

12345.6789

#,##0.##

12,345.68

12345.6789

#,##0.###

12,345.679

12345.6789

#,##0.00000

12,345.67890

12345.6789

#,##0

12,346

12345.6789

#,##0.00

12,345.68

12345

#,##0.##

12,345

12345

#,##0.00

12,345.00

.12

#\%

12%

.12

#.00\%

12.00%

.1234

#.##\%

12.34%

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.

PreviousExport to PDF.NextGradient Threshold

Last updated 6 months ago