Periscope Data Documentation

Connecting to Periscope

First Time Connecting

Connection Definitions

Common Connection Errors

Private Network SSH Tunnels

Integrations

Overview

Getting Started

Keyboard Shortcuts

Charts & Dashboards

Chart Overview

Chart Options

Dashboard Overview

Refresh Mechanics

Organizing Charts

Organizing Dashboards

Table-like Charts

Table Overview

Cohort Grids

Pivot Tables

Graph-like Charts

Overview & General Settings

Chart Types and Settings

Mixing Chart Types

Map Charts

Map Chart Overview

Heatmaps

Clusters and Bubbles

Satellite Maps

GeoJSON

Other Charts & Customizations

Pie Charts

Image Charts

Chart Annotations

Site Administration

Adding Users

Removing Users

User Types

User Groups

Two-Factor Authentication

Managing User Permissions

Dashboard Permissions

Site Preferences

Periscope Cache

Caching Strategies

Querying the Periscope Cache

Cross-Database Joins

CSV Upload

Materializing Views

SQL Formatters

Using SQL Formatters

Composing SQL Formatters

Dollars and Percentages

Time Zone Formatters

Date Aggregation

Date Parts

Basic Filters

Custom Filters

Date Range Filters

Aggregation Filter

Adding, Moving, and Hiding Filters

Advanced Filters

Default Filters

Drilldowns

Parent-Child Filters

Matching Filter Values

Time Zone Conversions

Direct Replacement

User Friendly Names

Views

SQL Views

Joining to Views

More SQL Tools

SQL Snippets

Parameterized SQL Snippets

SQL Alerts

Automatic Joins

Sharing and Embedding

Sharing Dashboards Externally

Email Reports

Easy Embedding

Embed API

Embed API Options

Public CSV URL

Slack API

Slack Linking Reports

Data Management

Adding and Deleting Datasource

Spaces: Data-Level Permissions

Improving Query Throughput

Revoking Table Permissions

Salesforce Datasource

SSO Integrations

Overview

Okta

OneLogin

Google Apps

Drilldowns

To view this documentation for the Periscope Classic UI, click here.

Drilldowns are a powerful way to dig deeper into the data and gain immediate insights into the make-up of aggregated information.

For a chart with a Drilldown, double clicking a data point will redirect the user to the target dashboard with filters applied from the value of that data point.

Creating a Drilldown

To create the drilldown, click the pencil icon on the source chart.

In the Chart Format tab, open up the Advanced dropdown, and scroll down to the Drilldowns section at the bottom.

First, choose the target dashboard where the drilldown will redirect.

Next, in the left dropdown select the column name of the source chart.

In the right dropdown select the filter name of the target dashboard. In this case, the filter on the target dashboard is called Device. You can learn more about filters here.

The column-filter mapping will only work when the column values of the source chart match the filter values of the target dashboard's filter. In this example, both the column and filter values are taken from gameplays.platform.

Once the chart is saved, the drilldown is good to go. To drilldown into the data, double click a data point in the chart to be taken to the dashboard populated with the filter values using that data point.

A drilldown-enabled chart can be identified when the cursor changes to a hand while hovering over a data point.

Deleting a Drilldown or Its Mappings

Deleting drilldown feature from a chart

In the Drilldowns section of the Chart Format tab of the chart, choose None (the first option) for the target dashboard dropdown. This will completely remove the drilldown feature once the chart is saved.

Deleting one or more mappings of a drilldown

In the Drilldowns section of the Chart Format tab of the chart, click the Delete Mapping link. One or more column to filter mappings can then be deleted from the drilldown. After saving the chart, the drilldown mappings will be removed.

Notes and Tips

Selecting a column

To add a column as part of the drilldown mapping without modifying visual changes to the graph, a column can be included in the SELECT statement of the query while not begin added in the in the Series Settings tab.

Drilldown to same dashboard

The target dashboard can be the same as the source dashboard.

Target dashboard/target dashboard filter name change

Drilldown mappings will automatically update the dashboard name and filter names.

Source chart column name change

Column name changes in the source chart will not automatically update in the drilldown mapping.

Multiple columns mapped to the same filter

If multiple columns are mapped to the same filter, the target dashboard will use the values from all columns. If the filter is a radio-button filter, only the first column's value will populate the filter.

Mappings to parent-child filter

In order to correctly map to parent and child filters, the value pair for the parent and child in the source chart must be an existing parent-child value pair in the target dashboard's parent and child filters.

Supported Chart Types

Drilldowns are supported on all chart types except for transposed tables, cohort grids, pivot tables, and number overlays that only return a single value.

Auto-generated series

Calculate Cumulative, Proportional Bar and Proportional Area, and Pie Charts are valid data points to be used in drilldowns. The generated value will be populated in target dashboard filters.

Rolling Average and Calculate Total in Tooltip are not supported in drilldowns.

Sharing and Embedding

Drilldowns are not enabled for shared dashboards. Drilldowns in embedded dashboards are possible through PostMessages. Details can be found in our Embed API Options Documentation.

Common Errors

  • The target dashboard is deleted.
  • The user does not have view permissions on target dashboard.
  • The filter is deleted.
  • The filter is hidden on target dashboard.
  • The data point value is not an existing filter value.
  • If the filter is a child filter, the correct parent is not selected.

Valid Drilldowns

A drilldown is a mapping between columns of a chart and filters of a target dashboard. In order to create a drilldown the following conditions have to be met:

  1. The target dashboard already exists.
  2. The filters of the target dashboard exist and are not hidden
  3. The column values of the source chart can be matched to filter values (not filter names) in the target dashboard's filter.
  4. The filter in target dashboard is used in target dashboard's charts.