Explore the Data in a Story Shared with You

Use Explorer Mode to analyze the data in a story. You can analyze every dimension or KPI in the story that is not restricted by the story owner, view the data in other chart types or tables, see default views set by the story owner, or add and save additional views.

Access Explorer Mode
  1. Click anywhere within the area of a chart or table to open the Action Menu. Expand (More Actions) to see all the options available in the menu.
  2. Select a chart or table, and then select (Explore).

If some explorer views have been added to a chart, the charts subtitle will contain the amount of available views. Simply click on the link to access the view.

Navigating Explorer Views

The Explorer can contain multiple views that you can navigate as you do with story pages. Each view is in a predefined tab. Simply click on the tab's name to switch to it.

Create new views by clicking + New View, then Edit to give your view a new name.
Note
You can make a view the default view by selecting Set view for explorer default. The selected chart or table will appear when explorer is opened.
Explore Your Data

When you select measures and dimensions in the upper pane, the visualization in the lower pane updates in real time. You can filter dimensions by selecting individual members, and the visualization changes immediately to show you the filtered result.

For example, you can click on the Discount % measure to enable it in the chart, then click on California from the Location dimension to filter the results and only show the state.

To remove a measure or dimension from the chart, click on it again.

For dimensions, you have the following selection options:

  • Click the dimension header to enable or disable it in the visualization.

  • Click a dimension member to apply or remove a filter on this element.

  • Click Access Other Interactions to open a context menu and do the following:
    • Select a hierarchy (if available)
    • Change the sort order
    • Select display options
Select a Visualization Type

The visualization type is chosen automatically based on the selected data, but you can change it to any of the types supported for your data.

To change the type of visualization, click the label on the top right corner of the lower pane and select a different type of chart or table.

For example, you can change the chart to a Stacked Bar/Column.

.

For more information, see Choosing the Best Chart Type for the Data.

Customize Your Chart with the Builder and Refresh your Data

In addition to changing the type of visualization, you can also automatically or manually refresh the data in the visualization and open the chart builder to build and customize your chart.

The builder can help you switch dimensions and add or remove filters easily. Drag and drop dimensions, measures, or filters and the visualization will be updated.

Explore Tables

  • Show/Hide- click the menu and then Show/Hide to show or hide the elements in a table.

    This way you can control which information is displayed. For example, you can choose to hide Dimension Headers.

  • Set Drillstate- set the drill level or drill state of the whole table content using the context menu and choosing the Dimension and Drill Level.

  • Edit Drill Limitation - When there are too many rows in your table only 500 are displayed and you get a warning. You can click on the icon and then Edit Drill Limitation to increase the table size. Keep in mind that when you increase the number of rows the number of columns will decrease to preserve the recommended limit.

Tips and Best Practices

  • Hide all the dimensions and only add the ones you require for your visualization. This improves performance in navigation.

  • Use the Builder to refine the Visualization. You can more easily build charts with multiple dimensions and tables using the builder. For example, in a table you can move dimensions to rows, columns, or filters.

  • Save your view in a bookmark

    Create a new view by clicking + New View and Edit to give your view a new name. Then, click Exit Explorer Mode to leave the explorer and save your story in a bookmark .

    The Explore view will be available directly after loading your bookmark.

  • You can export the data to excel or csv by clicking Export.