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:
- Select a grid visualization.
- 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