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
  • Properties Menu - Manage Column Grouping
  • Creating Column Groups
  • Deleting Groups
  • Enhanced Metric Organization with Row Metric Grouping in Version 5.2.5

Was this helpful?

  1. GRID/MICROCHART GUIDE

Manage Column Grouping

PreviousManage Scaling GroupingNextManage Metric Grouping

Last updated 23 days ago

Was this helpful?

Properties Menu - Manage Column Grouping

In the vitara grid chart, we can also group the columns which is called ‘column grouping’. Groups can be created with only attributes or only metrics or combination of both. Below screenshot shows the column groups created in the Grid chart.

In the above image, there are two column groups ‘Year&Month’ and ‘KPIs’ of which the first group is in expanded state and the second column is in collapsed state.

The groups can be expanded or collapsed. If the group is in a collapsed state, then only the first object in the group will be shown on the chart. And the remaining objects can be seen only if the group is expanded. By default, the newly created groups will be collapsed.

Creating Column Groups

Let us look into creating column groups in simple steps.

Step 1:

Open the hamburger menu of a column and hover onto Grouping, then a submenu opens. See the screenshot below

Step 2:

Click on ‘Manage Column Grouping’. Then a new window will open. See the screenshot

Step 3:

Click on ‘Add new’ to create a column group. Then a menu will appear with group title textbox and dropzones.

Step 4:

Now, drag and drop the objects from the left panel into the dropzone and set the group titles. In this case we are creating two groups as below: ‘Year&Month’ grouped with attributes ‘Year’ and ‘Month’ ‘KPIs’ grouped with metrics ‘Cost’, ‘Profit’ and ‘Revenue’. See the below screenshot

Step 5:

Close the ‘Manage Column Grouping’ window.Then the groups look like in the below screenshot

Deleting Groups

We can also delete the groups using the below steps.

  1. Open the ‘Manage Column Grouping’ window as described above in steps 1 and 2.

  2. You will find the ‘Delete Group’ text-button for each group. See the screenshot below

  1. Click on ‘Delete Group’, then that particular group will be deleted. Do this for whichever group to be deleted.

Enhanced Metric Organization with Row Metric Grouping in Version 5.2.5

From 5.2 version Users can now an ability to create groups for attributes and metrics by holding the ‘Ctrl’ key on the keyboard and selecting the desired attribute/metric which are to be grouped.For more details please refer to the

In the latest release (version 5.2.5), we’ve introduced a powerful feature called Row Metric Grouping, allowing users to efficiently organize metrics when they are moved to rows. This functionality provides a streamlined way to group and categorize metrics based on specific criteria. To gain a deeper understanding of this feature and its benefits, explore the distinctions between Metric Grouping and Column Grouping. This comparison will guide you in optimizing your metric organization for a more intuitive and structured presentation of data. For more detailed insights, click to delve into the nuances of Metric Grouping versus Column Grouping.

Custom Editor
ManageMetricGrouping