MicroStrategy ONE

Show Data Dialog

Use the Show Data dialog box to examine the underlying attribute and metric data of a visualization in a simple grid format.

Access

To access the Show Data dialog:

  1. Select a grid visualization.
  2. Click More in the top right of the visualization and choose Show Data.

Fields

Add Data : Click to add data from the visualization's primary dataset to the grid.

Rows: Displays the number of rows in the grid.

Export Data: Select this drop-down to export the data on this dialog to Excel, PDF, or CSV format.

Add as Grid: Click to create a new grid visualization using the data in the grid.

Grid: Displays the underlying data for the selected area of the visualization. You can perform the following actions in the grid:

  • Resize columns by clicking and dragging column edges.
  • Reorder columns by clicking and dragging headers.
  • Sort columns by selecting the drop-down in the column header and choosing Sort Ascending or Sort Descending.
  • Copy the grid data to the clipboard so you can paste it into another application. Click on a row to select it for copying. Press and hold the Ctrl key to select specific rows. Press and hold the Shift key to select consecutive rows. Then press Ctrl + C to copy the data to the clipboard.

The Show Data dialog box is not available for visualizations created using the data in a dataset imported from a server.

Related Topics

Examine the Underlying Data in a Visualization

Define the Primary Dataset for a Visualization

Create a Classic Grid

Introduction to Groups