MicroStrategy ONE

Create a Compound Grid

A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. Each column set can appear differently as thresholds, advanced filters, and formatting can be applied to each set.

  1. Open a dashboard.
  2. In the top toolbar, click Insert Visualization .
  3. Choose Grid > Compound Grid .
  4. In the Datasets panel, double-click attributes and metrics to add them to the visualization. A compound grid requires at least one attribute and one metric.
  5. In the Editor panel, click Add Column Set to create another column set.
  6. Double-click a column set name to rename it.
  7. To add an advanced filter for a specific column set, click More in the upper right corner of the visualization and choose Edit Filter.
  8. Select a column set and click Add New Qualification. See Manage Qualifications for an Advanced Filter for information on adding qualifications.

  9. In the Format panel, select formatting options for a specific column set by choosing Column Headers or Values in the first drop-down. Then, choose the column set from the second drop-down.

Related Topics

KB483841: Known issues when using a slicing selector to target a Compound Grid visualization