Explore Page Interface
  • 20 Apr 2022
  • 5 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Explore Page Interface

  • Dark
    Light
  • PDF

Overview

In this article, we will explore the different user interface elements found in the Explore page.


Screen Interface

New_Explore_Page_Interface


Dataset Panel

Location

New_Explore_Page_Dataset_Panel

Purpose

The Dataset panel displays the currently selected dataset. Functionality available via the vertical ellipsis icon include:

  • Edit dataset: Provides access to the semantic layer, where you can modify metrics, columns, and calculated columns.
  • Change dataset: Select to change your active dataset.
  • View in SQL Lab: Opens up the selected database in SQL Editor.

Dataset_Pane


Metrics & Columns Panel

Location

New_Explore_Page_Metrics_and_Columns_Panel

Purpose

This panel lists all of the metrics & columns found within your active dataset. If you are working with a large dataset, then the Search Metrics & Columns field enables you to quickly find the data you need.

Each data type includes a small icon that conveys its type:

  • ƒ: Function used for metrics
  • Clock: The datasource's time column (used below)
  • ABC: Text data
  • #: Numeric value data

This panel looks as follows:

New_Explore_Page_CloseUp_Metrics_and_Columns_Panel

Using Tooltips

Configuring Tooltips

Confused about a metric or column? Don't remember its purpose? No problem! You can quickly view the name, label, and a description of any metric or column using tooltips. Better yet, you can even customize your own description!

In this example, we will add a description to a metric, so let's get started.

To start, in the Dataset panel, select the vertical ellipsis and, in the sub-menu, select Edit dataset.

Edit_Dataset2(1)

In the Edit Dataset panel, select the Metrics tab and expand the count row.

In the Description field, enter your tooltip text. In this example, we entered "Count data".

Description_via_Edit_Dataset

Select Save.

Be sure to select OK in the subsequent save confirmation window.

Add_Tooltip_Description_Save_Confirmation

To see your new tooltip in action, just hover your cursor over the metric.

Add_Tooltip_Description1

Great work! In addition to the new description, the tooltip also displays the Metric name and the label being used.

You can do the same for columns and calculated columns — just select the appropriate column when editing the dataset and then complete the relevant Description field, as needed.

The Calculator Icon

When hovering your cursor over the calculator icon, a tooltip appears dsplaying the underlying SQL code for a metric:

Example_1_Calculator_Tooltip

...or a column:

Example_2_Calculator_Tooltip


Chart Type Panel

Location

Interface_Explore_Page_Chart_Type_Panel1

Purpose

The Chart Type panel is used to change your visualization type. It can be used at any time, so feel free to change charts to see different ways to display your data!

To change chart type, select current visualization type:

Change_Chart_Type3

The Select a visualization type panel appears featuring the Chart Gallery interface.

Change_Chart_Type4

From this panel, you can filter charts based on recommended tags and categories, as well as search for keywords. To learn more about how to use the Chart Gallery to select a different chart type, please see Create a Chart.


Time Panel

Location

Interface_Explore_Page_Time_Panel1

Purpose

The Time panel is used to specify the time-related elements of your query.

Key fields include:

  • Time Column: Select the data column responsible for time; this is usually pre-selected for you. You can find it in the Dataset panel — just look for the column with the clock icon!
  • Time Grain (in selected charts): The time granularity you wish to apply, such as day, week, month, etc.
  • Time Range: Preset will retrieve data from the date range you define here.

Time_Panel1


Query Panel

Location

Interface_Explore_Page_Query_Panel1

Purpose

In this panel, you will define the query that Preset will use to build your chart. There are a wide variety of charts in Preset, so some charts use different fields based on the type of data being retrieved.

Generally, query fields are designed to answer these questions:

  • Which data to include? (e.g., Series, Metric fields)
  • How to organize data? (e.g., Group field)
  • How to limit data? (e.g., Row limit, Filter fields)

To learn more about the usage of the Query panel, just browse through some of the available charts in the Superset Charts chapter, such as the Pie Chart, Line Chart, Area Chart, and Pivot Table.

Query_Pie_Chart(1)


Content Panel

Location

Interface_Explore_Page_Conent_Panel1

Purpose

The Content panel displays the actual visualization and also includes these additional features:

  • Chart title
  • Favorite/unfavorite
  • View chart version differences
  • No. of rows
  • Force refresh
  • Query processing time
  • Schedule e-mail report

...and these chart tools:

Chart_Tools

  • Copy permalink to clipboard: Copies the URL address of the chart to your clipboard.
  • Share permalink by e-mail: Launches your system's default e-mail client with the chart URL included in the body of a message.
  • Embed code: Provides an <iframe> embed code.
  • Export to .JSON format: Download the chart to a local or network location in JSON format.
  • Export to .CSV format: Download the chart to a local or network location in CSV format.
  • Triple Bar / Burger icon: Provides additional options, which are:
    • Edit properties: Enables you to change the properties of the chart, such as the name, description, and owners.
    • View query: Launches the View query panel and displays the chart's query in SQL.
    • Run in SQL Lab: Launches the SQL Editor and loads the chart's query in SQL.
    • Download as image: Download the chart to a local or network location in JPEG format.

Data Panel

Location

Interface_Explore_Page_with_Data_Panel2

Purpose

Below the chart there is an expandable section called Data. If you select Data, this section expands and displays the following:

View results tab

The View Results tab, displayed by default, displays the results of the query in terms of the selected metrics & columns.

Data_View_Results

View samples tab

The View Samples tab displays actual raw data, with the amount of data displayed based on the value specified in the Row Limit field.

Data_View_Samples

Sort temporal columns

In the Data panel, you can modify the formatting of time-related content to display in either an epoch format (i.e., original value) or a formatted value (i.e., YYYY-mm-dd HH:MM:SS).

To do this, select the gear icon in any temporal column header:

Temporal_Column_Select_Gear_Icon

...and, in the sub-menu, select Original value or Formatted date, as needed):

Original value (default)

Temporal_Column_Original_Value

Formatted date

Temporal_Column_Formatted_Date


Customize Tab

Location

To access chart customization options, just select the Customize tab.

Select_Customize_Tab

...and customization options will appear.

Interface_Explore_Page_with_Customize_Tab2

Purpose

Most Preset charts offer customization options, such as changing the layout, adding labels, or changing the color scheme. Every chart offers its own unique customization options, so be sure to select the Customize tab to see what's available for your chart type!

In the example graphic below, these customization options are for a Time-series Bar Chart.

Customize1


Run and Save Query

Location

Interface_Explore_Page_Run_and_Save2

Purpose

Run the query

To run your query, select Run. Alternatively, you can select Run Query in the middle of the Content panel.

The Content panel will display your chart based on the current configuration settings.

Save the chart

To save your chart, select Save.

Save_Chart(1)

The Save chart panel appears.

Select the Save as... option and then select Save. You'll notice that the Chart Name field is already populated with the title — you can change this if you like.

Save_As


Was this article helpful?

What's Next