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 - Column Total
  • Column totals when Grouping is enabled
  • Column Totals with Pivot
  1. GRID CHART GUIDE

Column Totals

PreviousAuto SizeNextCustom markers

Last updated 3 days ago

Properties Menu - Column Total

In Vitara charts, column totals feature is implemented in the Grid chart. By default, the column total is not shown. We have to enable the Column Totals in the ‘SubTotals’ property in the property editor.

The only default aggregation for Column Totals is “Sum” of the metrics in the chart.

Below is the screenshot where the column totals are in enabled state in the property editor.

Below is the screenshot where the Column totals is enabled and ‘Total’ column is displaying in the chart calculationg the metrics in the chart.

Column totals when Grouping is enabled

Group any attirbute in the chart, and enable the column totals in the property editor. The totals column can be added where the totals are calculated acorss the metrics.

Below is the screenshot where the grouping is applied on Category attribute and ‘Total’ column is calculating across the metrics ‘Cost’ and ‘Revenue’.

Column Totals with Pivot

To get totals across the metrics in the chart.

Pivot any attribute in the chart and the other attributes automatically gets grouped in the char. Enable the Column Totals in the Sub totals property. Now you can see the ‘Total’ column calculated across the metrics.

Below is the screenshot where Category attribute is pivoted and Total is calculated across the Cost and Profit metrics.

To get totals on a single metric next to the attribute.

Assume two attributes and two metrics are added to the Vitara Grid chart. Apply ‘Move to Rows’ on any metric in the chart, then Pivot the ‘Metrics’ column along with a attribute and the other attribute will be automatically grouped. Make sure the ‘Metrics’ column should be in the first position of the Pivot zone.

Below is the screenshot where the Category, Quarter are the two attributes and Cost, Revenue are the two metrics added to the chart. The ‘Mover to rows’ is applied on a metric in the chart and the ‘Metrics’ column is pivoted along with the ‘Category’ attribute.

Enable the Column Totals in the Sub totals property. Now you can get the Totals on a single attribute next to the attribute in the chart.

Below is the screenshot shown where Total column is shown when ‘Metrics’ column and Category attribute are pivoted and Quarter attribute is grouped. Now you can see the totals on the ‘Cost’ metric next to the Quarter attribute.

Enhancement :Column Totals option will only be used to display total columns in non-pivoted charts. When using a pivot, this option will be hidden. Two new options have been added to the Subtotal tab: Pivot Row Total and Pivot Group Total. for detailed information.

Click here