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
  • Subtotals
  • Show pivot Metric Totals
  • Introducing Pivot Row Total and Pivot Group Total for Advanced Subtotaling
  1. GRID CHART GUIDE

Subtotals

PreviousSortingNextThresholds

Last updated 21 days ago

Subtotals

A subtotal lets you see the totals for subgroups of your report data. Vitara Grid chart shows the Subtotals when you group by any column. The subtotal functions include sum, count, minimum, maximum, average, first, last and Ratio in Vitara Grid chart.

Subtotals editor by default enables the ‘Use body styles’ option where it is shown same as body styles of the chart; and we cannot do text formattings on Subtotals. Below is the screenshot shown where ‘Use Body Styles’ is enabled.

In Subtotals editor, if we disable the ‘Use body styles’ option, you can do the text formatting options and apply background color to the Subtotals; 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 subtotals.

Show pivot Metric Totals

We introduced a new feature called “Show pivot Metric Totals” . By toggling the “Show Pivot Metric Totals” option in the subtotal tab, we can easily view the individual metric totals. This feature allows us to see the sum of each metric within the pivot, providing a comprehensive overview of the data.

This new option provides a convenient way to view data in grouped form. When the group is collapsed, the total for that group will be displayed, giving an overview of the data at a glance. This is particularly useful when working with large sets of data, as it allows for quick analysis without having to expand each individual group.

On the other hand, when the group is expanded, the individual data within that group will be shown. This allows for a detailed examination of each data point, providing a comprehensive understanding of the data set. With this option, users can easily switch between the total and individual views, depending on their specific analysis needs. The sample gif file is provided below.

Introducing Pivot Row Total and Pivot Group Total for Advanced Subtotaling

Enhancement : The option “Show Pivot Metric Totals” has been renamed to “Pivot Group Metric Totals.” This feature is only available when there are two or more attributes in the pivot drop zones; otherwise, it will be disabled. Additionally, two new options have been introduced: Pivot Row Total and Pivot Group Total.

Note : All three options will only be visible when a pivot is active. You can only select one of the following options at a time. Activating one will automatically disable the other.

  • Pivot Group Metric Totals

  • Pivot Group Totals

Enhancements : Pivot Row Total and Pivot Group Total

Introduces two powerful new options within the Subtotal tab: Pivot Row Total and Pivot Group Total. These features significantly elevate the data analysis capabilities, offering users greater flexibility and precision in how subtotals are calculated and presented.

Pivot Row Total

The Pivot Row Total option allows users to generate subtotal values of metrics for each row in a pivot table. This feature is particularly useful when you need a clear, row-by-row breakdown of totals within a dataset. It ensures that users can see the sum of data for each specific row category, facilitating easier comparison and analysis across individual records.

By enabling the Pivot Row Totals option, as shown in the screenshot below, you can see the subtotal of metrics such as cost and profit, which sum up the data for each category.

Pivot Group Total

The Pivot Group Total option introduces the ability to calculate and display subtotals for grouped data within a pivot . This feature is ideal for scenarios where data is categorized into groups (e.g., departments, regions, or product lines), and a summary total for each group is needed. By consolidating group data, it provides a more streamlined view of overall data.

By enabling the Pivot Group Totals option, as shown in the screenshot below, you can see the subtotals of grouped data of cost and profit , which sum up the data for each group within the pivot.