LogoLogo
  • CHARTS USER GUIDE
    • Introduction
    • Angular Gauge Chart
    • Bar/Column Chart
    • Bubble Chart
    • Bullet Chart
    • Calendar Heatmap Chart
    • Column Range Chart
    • Combination Chart
    • Dumbbell Chart
    • Filter Chart
    • Funnel Chart
    • Grid Chart
    • Table heatmap
    • Histogram Chart
    • KPI Animation Chart
    • KPI Ring Chart
    • Line/Area line Chart
    • Mekko Chart
    • Packed Bubble Chart
    • Pie Chart
    • Polar Charts
    • Sankey Chart
    • Simple KPI Chart
    • Slope Chart
    • Sparkline Chart
    • Stacked Column/Bar
    • Text Node
    • Tornado Chart
    • Trellis Chart
    • Variwide Chart
    • Waffle Chart
    • Waterfall Chart
    • Wordcloud Chart
    • Workstation
    • Allow/Block URLs
    • Animation Duration
    • Attribute Forms
    • Auto Scroll
    • Axes
    • Background Images
    • Backward Compatibility
    • Bar/Column Width
    • Color Picker with Opacity
    • Connect Null Points
    • Custom Markers
    • Custom SVG Markers
    • Data Markers
    • Data label customization
    • Dossiers/Documents differences
    • Drilling
    • Error Bars
    • Export to PDF
      • Export engine local resource set up
    • Formatting metric data
    • Gradient Threshold
    • Legend
    • Negative Sign
    • Pattern Fill
    • Play Animation
    • Plot lines/Reference lines
    • Reset color property
    • Reset font properties
    • Right Click Menu
    • Right-to-left Support
    • Series using Attribute
    • Small Multiples
    • Smooth Line
    • Tooltip Customization
    • Tooltip Links
  • GRID/MICROCHART GUIDE
    • Appearance
    • Auto Size
    • Column Totals
    • Context Menu
    • Creating a micro chart
    • Custom markers
    • Custom Editor
    • Filter Data
    • Format/Clear Format
    • Grand Total
    • Pivoting and Row Grouping
    • Horizontal Bars/Pins
    • Embed Images
    • Manage Scaling Grouping
    • Manage Column Grouping
    • Manage Metric Grouping
    • Pin Column
    • Reorder columns
    • Reset Columns
    • Show/Hide Column
    • Sorting
    • Subtotals
    • Thresholds
    • Tooltip
    • Transparency
    • Trend Lines
    • Value Aggregation
    • Variance
  • MAPS USER GUIDE
    • Creating New Maps
    • Custom Layouts
    • Customization of the Map chart
    • Default Maps
    • Formatting Options
    • Generic Merge tool
    • US map using counties data
    • US Map using ZIP Codes
  • IBCS USER GUIDE
    • IBCS
      • Why IBCS
      • Mapping IBCS Scenarios
      • Negative Metrics
      • Scaling Multiple Charts
    • CERTIFIED CHARTS
      • Multi-tier Bar chart
      • Multi-tier Column chart
      • Small Multiples
      • Vertical Waterfall
  • CUSTOMIZATION GUIDE
    • Introduction
    • Custom CSS
    • Custom CSS Samples
    • Custom Color Palette
    • Custom Fonts
    • Condensed Metric Format
    • Disable Edit button
    • Grid Custom CSS
    • Localization
  • FAQ
    • Contact Us
    • FAQS
  • INSTALL DOCS
    • Installing on MicroStrategy Web
    • Installing on MicroStrategy Desktop/Workstation
    • Installing on MicroStrategy Library
    • Installing on MicroStrategy Mobile
    • Release Notes
    • Release Notes Maps
Powered by GitBook
On this page
  • Inputs
  • Grouping
  • Aggregations
  • Thresholds
  • Sorting
  • Look and feel
  • Filters
  • Show/hide the number of children in a row group:

Was this helpful?

  1. CHARTS USER GUIDE

Grid Chart

PreviousFunnel ChartNextTable heatmap

Last updated 1 month ago

Was this helpful?

Note: A separate detailed ‘Grid and MicroChart usage document’ is available. to access it

The Vitara grid is the easiest to use grid. With a single click, we can access an infinite number of options. Grid formatting is provided at both the column and row levels, as well as appealing grid themes, the ability to group (Page by) at many levels, metric aggregations (Subtotals) at various grouping levels, column grouping, thresholds with custom icons, and many other features.

Inputs

Metrics: 1 metric Attributes: At least 1 attribute Use as Filter Option - Available

Using the Vitara grid chart it’s so easy to apply the following options.

Grouping

We can apply to the group, both at column level and row level. Expand/collapse grouping. For group headlines, we can apply aggregations. Further, we can show grand totals for grouped metric aggregated headlines.

Aggregations

We can show aggregations (Subtotals) on groupings. Enable or disable grand totals.

Thresholds

Apply/remove thresholds easily. In thresholds, we can set the background color, text color, icons, icon color, icon size, icon only and use custom images as icons.

Sorting

The column data can be sorted in either ascending or descending order with only one click on the column header. Data will be sorted in ascending order on the first click, descending order on the second click, and sorting on a column will be removed on the third click. There is also a “Clear Sorting” tab that will reverse the sorting that has been performed to every grid column.

Look and feel

Auto size fit to the content/ fit to grid width, grid themes, set grid row height, option for clear sorting/clear threshold/clear grouping/clear filter, export grid data into CSV format, pin a column to the right/left side. Text font properties like font style, font size, alignment, text color, bold, underline and italic are available for column headers and body text.

Filters

View filters can be created specifically to the grid i.e filter on attribute or metric.

Show/hide the number of children in a row group:

Grid/Micro chart’s 3.8 edition added the ability to show or hide the number of children in a row group. The number of children in a row group can be shown or hidden in grid/micro charts. Click the ‘Edit’ button, then select ‘Grid Theme’ and check the ‘Hide Children Count’ checkbox in the properties popup window.

Click here