Downloading data provides a way for you to quickly copy Look or Dashboard data to the Downloads folder on your local computer . And before you ask, no, you can't download data to a different computer/storage location. In fact, you can’t even specify a different folder: when you download data it automatically gets stored in your browser’s assigned downloads folder. Admittedly, that limits your options a bit. On the other hand, it makes for a very quick, very easy way to download data for yourself. And that’s exactly what the feature is intended to do.
Dashboards provide two options for downloading data: you can download the dashboard as .PDF file (which gives you a read-only replica of the dashboard) or you can download the data as a set of CSV (comma-separated values) files, one file for each visualization on the dashboard.
To download data from a Dashboard, click the Settings icon and then click either Download as PDF or Download as CSVs:
If you are downloading CVS files, the download will take place immediately. If you’re downloading PDF files, you’ll see a dialog box where you can confirm the download and specify whether you want a regular PDF file or a single-column PDF file, and whether you want to download the file to your computer or simply view the file in your web browser:
By comparison, Looks provide only one for downloading data: Download. However, this lone option brings up the Download dialog box:
That dialog box does give you numerous options for downloading the data and visualizations use by the Look:
Specifies the file format for the downloaded file. Valid formats include:
- TXT (tab-separated values). Plain text file with data fields separated by using tabs.
- Excel Spreadsheet (Excel 2007 or later). The downloaded file includes the raw data but does not include any visualizations options such as row color.
- CSV. Plain text file with data fields separated by using commas. If a field contains a comma (for example, January 1, 2018) that field will be enclosed in double quote marks: “January 1, 2018”.
- HTML. Data is downloaded as an HTML file, formatted to match the format of the visualization.
- Markdown. Data is downloaded as an unformatted table using the Markdown markup language.
- PNG (Image of Visualization). The download consists of a “snapshot” of the visualization. Data can be viewed but cannot be manipulated.
Specifies whether your download will reflect options configured for the dataset table. You must select one of the following:
With visualization options applied: Data is downloaded after applying the
visualization settings. These settings include:
- Show Row Numbers
- Hide Totals
- Hide Row Totals
- Limit Displayed Rows
- Show Full Field Name
- Custom Labels
- As displayed in the data table: Data is returned without applying visualization settings.
For example, suppose you create custom labels for each column in your table chart. With visualization options applied, the returned data (and the column headings) might look like this:
Country,City,Zip Code,Total Number of Users Canada,Kitchener,N2H3T2,1Canada,Halifax,B3M1N1,1
If visualization options are not applied, the returned data and column headings would look like this, with field names used in the header row instead of custom labels:
Location Dim Country,Location Dim City,Location Dim Postal Code,Location Dim Count Canada,Kitchener,N2H3T2,1 Canada,Halifax,B3M1N1,1
Specifies whether data is returned using any applied numeric formats (such as rounding numbers) or is displayed in its “raw” form. You must select one of the following:
- Formatted: Data is returned after applying numeric formats. This is the default value.
- Unformatted: Data is returned in its raw, unformatted state.
This typically applies to table calculations.
Specifies the maximum number of rows included in the downloaded file. Options include:
- Results in Table. The downloaded file contains the same number of rows specified in your Look. If the Look only allows 300 rows the downloaded file will only include 300 rows.
- All Results. Returns all the rows returned by the query; this will often be more rows than specified by the Look. Note that the All Results will not be available depending on such things as the size and complexity of the query, and whether the query includes “add-ons” like row totals or table calculations. This option should be selected only if you are sure that the resulting download will not tie up the network and/or your local computer.
- Custom … Enables users to specify the number of rows they can return. Depending on your user account permissions, the maximum number of rows will either be 5,000 or 100,000.
Name of the downloaded file. By default, Customer Insights creates a file name based on the name of the Look, a date and time stamp, and a file extension that indicates the file format. For example, in the file name Multiple Explores in a Single Look 2018-02-05T1106.csv:
- Multiple Explores in a Single Look is the name of the Look.
- 2018-02-05T1106 is the date and time that the file was downloaded (February 5, 2018 at 11:06 AM).
- .csv indicates that the file was saved as a comma-separated values file.
You can change the file name if you want. However, you cannot change the download destination: files are automatically downloaded to the downloads folder specified for your web browser.
After configuring download options, click one of the following:
- Open in Browser. When selected, the file is not downloaded to your computer but, instead, is opened in your web browser. Excel spreadsheet files cannot be opened in the browser.
- Download. When selected, the file is downloaded to your computer.