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
  • Properties Menu - Grand Total
  • Grand Total Threshold
  1. GRID CHART GUIDE

Grand Total

PreviousFormat/Clear FormatNextPivoting and Row Grouping

Last updated 7 months ago

Properties Menu - Grand Total

In Vitara grid chart by default shows ‘Grand Total’ row at the bottom of the visualization. The default function applied is ‘Sum’. However, we can modify the default aggregation function to other functions in the list.

Therefore, the term ‘Grand Total’ is just for naming purposes and does not mean it will show only totals. The actual value of the Grand total will be calculated by using the function applied in ‘Value Aggregation’. For example, if we apply ‘Value Aggregation’ function - Max, the grand total will also show the max value among the values. Show/Hide Grand total: If we don’t want to show ‘Grand Total’ row, then we can hide the ‘Grand Total’ row. Click on the ‘Edit’ button select the ‘Grand Totals’ tab and expand the dropdown box select ‘Hide’.

Now, you can do the text formatting options and apply background color to the Grand totals row; font family, font size, bold, italic, underline, text color, font alignment and back ground color. Below is the screenshots of ‘Title formatting’ and ‘Value formatting’ of Grand totals editor.

Examples of screenshots where the text formattings and back ground colors are applied for grand totals.

Grand Total Threshold

We introduced a feature that enables users to add ‘thresholds’ to the grand total row. To enable thresholds for grand totals, go to the thresholds tab in the editor window, then pick source and target, then select ‘Grand Total’ from the group option above the source, and apply desired threshold condition.