Support Portal

Downloading Data

This page discusses how to download the data or a visualization from a Look or from the Explore page in a variety of formats. Downloading dashboards is discussed separately on the Viewing Dashboards in Analytics page.

Downloading Data

This page discusses how to download the data or a visualization from a Look or from the Explore page in a variety of formats. Downloading dashboards is discussed separately on the Viewing Dashboards in Analytics page.

To download data from a Look or an Explore page, click the gear dropdown in the upper right and select Download:

File Formats

Data can be downloaded in the following formats:

  • CSV
  • Excel Spreadsheet (XLSX)
  • HTML
  • JSON
  • MARKDOWN
  • PNG (Image of Visualization)
  • TXT (tab-separated values)

Results

In the Results section, choose whether you want visualization settings applied to your data download:

  • If you choose With visualization options applied, Analytics applies some of the visualization settings to your download, causing your download to appear similar to a table chart. Any of the following settings in the Plot and Series menus that are configured for the visualization will be applied to the data download:
  • If you choose As displayed in the data table, visualization options will not be applied, and the download will appear like the data table in the Data section of the Look or Explore.

Values

In the Values section, choose how you want the downloaded query results to appear:

  • If you choose Unformatted, Analytics does not apply any special formatting of your query results, such as rounding long numbers or adding special characters your Analytics developers may have put in place. This is often preferred when data is being fed into another tool for processing.
  • If you choose Formatted the data will appear more similar to the Explore experience in Analytics, although some features (such as linking) aren’t supported by all file types.

Limit

You can choose how much data you want to download as follows:

  • Results in table - Number of rows specified by the row limit of your Look.
  • All Results - All results returned by the query. Before selecting this option, see the All Results section below.
  • Custom - A custom number of rows. 

All Results

When you click Run in a Look or an Explore, Analytics determines whether the complexity of the query and the database dialect will allow the entire query to be downloaded:

  • The All Results option is typically disabled for queries that have one of these characteristics:
    • involving row totals or table calculations
    • using percent of total, percent of previous, or running totals types of measures
    • getting data from a database dialect that can’t stream results
    • including pivoted columns that Analytics calculates because the data comes from a database dialect that can’t calculate the pivots

If Analytics determines that your entire query can be downloaded, the All Results option will be available in the Download window. Otherwise, the All Results option will be unavailable and you can instead use the Custom option to specify the maximum number of rows allowed with your permissions.

Remove All Sorts from Query

When you select All Results, you may also see the option to Remove all sorts from query. This option prevents sorting on your query before downloading the results. Selecting this option may speed up your download, since sorting a query can be costly to performance for certain database types. The Remove all sorts from query option is not supported for pivoted results. 

Download or Open in Browser

Once you’ve selected your options, you can click the Download button to download a file to your computer, or click Open in Browser to view the file in the browser.

After being able to download data, you can jump it the next tutorial to learn how to share and schedule data.

Sharing Data

Scheduling Data Deliveries

Expand Tables

To display all rows of a data table — rather than just those rows that display in the dashboard tile thumbnail — in a PDF dashboard delivery or download, check the Expand tables box.The Expand tables box option can be found under Advanced options in the schedule window. 

In case you want to schedule the 'Shipment List Dashboard' in a PDF format, select Expand tables to receive all rows and not only the first 30 visible in the dashboard.

Paper Size

You have the option to specify the optimal size and orientation of dashboard PDFs by selecting from the Paper size drop-down menu. Large visualizations or groups of overlapping dashboard tiles may need to be resized to fit cleanly on a PDF page.