Overview

Create an Exploration to build one-off, personal analysis that doesn’t show up in or change the original report.

Create an Exploration

There are a few ways to begin exploring. From within the Chart editor context, click the Explore button in the toolbar of any built-in chart or table.

explore from the chart editor

When viewing a Mode Report or Dashboard, hover over a visualization and click the Explore button, or click on a series to explore a more specific subset of the data.

explore from report view

When exploring you can change the chart type, drag and drop from the list of available fields, sort, drill down, filter your data, and apply chart formatting. When you’re finished, save your analysis by clicking the Save Exploration button. When saving, you will be prompted to add a title and a description for your Exploration.

save exploration

Below, we’ve outlined some of the key elements that will help you find your way around Mode’s Explorations.

When you begin exploring:

unsaved exploration

  1. ← Back to report - Directs you back to the report view
  2. Save Exploration - Saves a new Exploration

After you save your Exploration:

saved view exploration

  1. Share - Copies the Exploration link to your clipboard
  2. New Exploration - Creates a new Exploration based on an existing Exploration
  3. Edit - Opens your Exploration in edit mode
  4. Details panel - View information about an Exploration such as: last run time, which report it was saved from, what query it references and which filter values were applied

When you’re exploring:

exploring saved Exploration

  1. Gear icon settings-mini-hover Created with Sketch. - Access Exploration settings or delete the Exploration while in edit mode
  2. View - When editing your Exploration, click this to open the view mode
  3. Fields and Format panels - Access the list of available fields in the dataset and choose from formatting options

Toolbar

toolbar

  • Undo/Redo - Allows you to navigate through changes
  • Clear - Clears out an Exploration’s chart configuration, or its sort and filter settings
  • Swap axes - Switch between a horizontal and vertical chart type configuration
  • Quick sort - Sorts your discrete, categorical data by a measure in either ascending or descending order

NOTE: Table Charts contain additional options and formatting in the toolbar

Formatting your Exploration

You can access general formatting options in the “Format” panel. You can customize labels, hide and show elements like titles, and control the placement of things like the legend from here.

format your exploration

Working with your data

Explorations are powered directly by data from SQL queries. Every time the data refreshes, you’ll see the latest list of available fields and your visualization will include the latest data. Qualitative data will show up as a blue field in the Dimensions section and will generate a blue pill when dragged to a chart. Quantitative data will show up as a green field in the Measures section and create a green pill when dragged to a chart.

Once you understand your list of fields, you can start dragging fields into the drop zones. Change how a pill is aggregated by clicking the pill’s context menu.

Filters

When you explore in a report with filters, Mode will translate the relevant filters into your Exploration automatically. This is so the visualization will reflect what you were seeing on the report, and so that the filters will persist when you save your Exploration. Once you begin exploring, you can add or update filters.

When viewing an Exploration, you can see what filters are applied by clicking on the filter’s tooltip in the Details panel.

filters applied

Parameters

An Exploration will always reflect the latest report parameters. This means your Exploration’s data could change if someone updates the parameter values on the same report you originally explored from. At the top of your Exploration, you will see the current parameter values. Update them by returning to the report.

parameters applied

View saved Explorations

To return to any Explorations you’ve made and or view all of your saved Explorations, go to the My Explorations tab on the left side of your Mode home page. From here you can search and filter your Explorations, or view, edit, or delete an existing Exploration. Your list of Explorations is private and browsable only to you.

my explorations tab

Reports powering Explorations

Members in your workspace can only create and view Explorations when they have permission to view the report. If a query in your report powers an Exploration, you will see a status indicator in the right corner of the SQL editor. The tooltip will tell you how many Explorations are powered by your query’s data.

dependencies

IMPORTANT: Deleting a report or query will also delete all Explorations powered by that report/query. Please keep in mind, if you add or change the names of columns, those updates will show up in Explorations. Similarly, deleting any columns or Calculated Fields will also delete them from Explorations.

FAQs

Can I share my Exploration?

Yes. Once you save your Exploration, you can share the URL with others in your workspace. If they have permission to view the report, they can view your Exploration.

Can other people edit my Exploration?

No. However, when you share your Exploration with other members of your workspace, they can create their own Exploration, personalized to them, starting with what you shared.

Why did my Exploration’s data change?

By default, an Exploration will update automatically to show the latest successful run of the query powering it. If a Report runs on a schedule, or is manually refreshed, your Exploration will be refreshed simultaneously.

What happens if I delete a report powering an Exploration?

If deleted, these Explorations will be removed from the My Explorations view in Mode’s home page and navigating back to any existing URLs will result in a 404 error.

Last updated August 14, 2020