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
  • Manage Metric Grouping
  • Create Metric Groups
  • Deleting Groups
  • Functionality of Row Metric Grouping & Column Grouping

Was this helpful?

  1. GRID/MICROCHART GUIDE

Manage Metric Grouping

PreviousManage Column GroupingNextPin Column

Last updated 7 months ago

Was this helpful?

Manage Metric Grouping

From version 5.2.5, we have the ability to do row metric grouping, which means grouping metrics when they are moved to rows. The below screenshot shows the row metric groups created in the grid chart.

In the above image, two metric groups are created: KPIs, which contain cost, profit, revenue and Employee, which contains profit per employee and revenue per employee. Users can group single or multiple metrics via the metric grouping option in the hamburger menu.

a. This option will only exist when metrics are in row setup. b. Metrics that are not grouped will be shown “ungrouped”.

Create Metric Groups

Step 1:

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

Step 2:

Click on ‘Manage Metric Grouping’. Then a new window will open. Click on ‘Add New’ to create a group. Then a menu with a group title textbox and dropzones will appear.

Step 3:

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: ‘KPIs’ grouped with the metrics ‘Cost’,’Profit’,’ and ‘Revenue’. ‘Employee’ grouped with the ‘ profit per employee’ and ‘revenue per employee.’ See the below screenshot.

Step 4:

Close the ‘Manage Metric Grouping’ window. Metrics that are not grouped will be displayed as “ungrouped.” This is how the groups appear in the screenshot below.

Deleting Groups

We can also delete the groups using the below steps.

  1. Open the ‘Manage Metric Grouping’ window as described above in steps 1 & 2.

  2. You will find the ‘Delete’ icon for each group. See the screenshot below.

  1. Click on the ‘Delete’ icon then that particular group will be deleted. Do this for whichever group is to be deleted.

Functionality of Row Metric Grouping & Column Grouping

Column Grouping - Grouping of multiple columns. Row Metric Grouping - Grouping of metrics when they are moved to a row.

Rules:

  1. Column grouping & Row Metric grouping can co-exist.

  2. The column grouping of the various metrics as columns will transform into row metric grouping when the “Metrics” are moved to rows. E.g.,Cost, profit, and revenue metrics are column grouped and will be automatically row grouped when they are moved to rows.

  3. If you move row-grouped metrics to columns, the grouped metrics will be converted to column groups.

E.g., In the Move to Rows scenario, if cost, profit, and revenue metrics are Row Grouped, then when the user moves metrics to columns, these Row Grouped metrics will be Column Grouped. Accordingly Check the gif file for steps 1 and 2.

  1. Both the “Attribute” and “Metrics” columns were initially grouped together. If we later move the Metrics columns to the row, the Metric columns element will be row grouped, while the attribute will remain column grouped with the original group name.

E.g., The year attribute, cost and profit, revenue metrics are column grouped. When these metrics are moved to rows, the year attribute will remain column grouped and the “cost” ,profit and “revenue” metrics will be grouped in rows.

  1. Row Group and pivot operations can make use of the Metric Grouping column. The screenshot below shows metric group column in row groups and pivot operations.

See the image below. The Grouped column has been moved to row grouping.