| Available for | Roles | Super Admin, Admin, Team Member |
| Permissions | • View Visual Insights reports | |
| Packages | Lever Basic, LeverTRM, LeverTRM for Enterprise |
|
|
This article depicts and describes Lever's enhanced Data Exports for Visual Insights feature included in the Summer 2024 Product Release, scheduled to rollout progressively in August 2024. For full details, refer to our Summer 2024 Product Release Notes. |
Downloading data from Visual Insights allows you to maintain records and run your own calculations with your recruitment information outside of your LeverTRM environment. As you are reading, refer to our LeverTRM Glossary for definitions of the key terms and concepts used in this article.
In this article
Methods for downloading data
There are four methods for downloading data from Visual Insights.
Method 1: Downloading data from dashboards
To download all of the data from a dashboard at once, click the three stacked dots ⠇in the upper-right corner of the filters bar and select the Download option.
Next, select a format for the exported file.
If you select the CSV file format...
All data from the dashboard will be exported in a .zip file, containing one CSV spreadsheet for every individual chart on the dashboard.
If you select the PDF file format...
The dashboard will be exported as a single PDF containing all charts as they appear on the dashboard. Once you have selected the PDF file format, additional options will appear that you can use to configure the size and orientation of the charts on the exported PDF. Note that, by default, dashboards containing tables only show as many rows as are visible within the frame of the table on the exported PDF (i.e. rows that you would need to scroll to reveal on the live dashboard will not appear on the dashboard when it is downloaded as PDF). To show rows beyond what appears within the frame of the table, check the 'Expand tables to show all rows' checkbox before downloading.
Once you have selected a file format, click the Download button.
Method 2: Downloading data from charts
To download data from a chart, click the three stacked dots ⠇in the upper-right corner of the chart tile and click Download data.
A modal will appear in which you will be prompted to select an export format for the download. Once you have selected a format, click the Download button.
|
|
If the chart for which you are downloading data is a table and you select the PNG export format, note that only first 24 rows in the table will appear on the exported image. |
Method 3: Downloading data from drill down tables
Drill down tables appear when you click into a value on a chart. The table contains records for the opportunities, postings, or requisitions to which the events, measurements, or objects contributing to the drilled value are associated. Click the Download in the upper-right corner of the drill down table, select an export format for the download in the modal that appears, and then click Download button.
Note that drill down tables can list a maximum of 500 records. If the drilled value is comprised of data from more than 500 records, and you wish to download data from all records that comprise that value, follow these instructions before clicking the Download button in the modal:
- Click ▸ Advanced data options beneath the export format menu.
- Note: This button will not appear if you have selected the PNG export format for the download.
- Select the All results option under the Number of rows to include header.
For full details, refer to our help article on drill downs.
Method 4: Running bulk data exports
|
|
Bulk data exports can only be run by users with Super Admin level access or those that have had export permissions configured as such by a Super Admin. |
Bulk exports contain granular information and are ideal for data back-ups and record keeping. To run a bulk data export, click the chevron (>) on the left side of the page, click Exports and select the type of data export you wish to run from the expanded menu.
For a detailed description of how to export data in bulk, please refer to our help article on Visual Insights exports.
Data export formats
If you are downloading data, you may be required to select an export format in the modal that appears. The default selection is a CSV file format, however you will notice there are a number of other export formats from which you can choose.
When choosing an export format, it is best to think of the seven available options as being divided into two categories - Standard and Developer.
Standard export formats
TXT, Excel, CSV and PNG are considered 'Standard' export formats. In most cases, we recommend downloading data in a standard export format so you can easily manipulate the data with tools that are readily available to you, Standard export file types do not require additional applications or technical expertise in order to work with them.
Developer export formats
JSON, HTML, and Markdown are considered 'Developer' export formats. In most cases, we advise against downloading data using these export formats, as the generated files require development tools in order to access and manipulate the data. If you find that you are regularly need to download data in a developer export format, consider making use of Lever's Data Warehouse Sync option available with the Advanced Analytics add-on.
Getting developer assistance with an HTML export
In the event that you require data in an HTML export format, note that you will need the assistance of a developer at your organization to link the values in the file back to the Visual Insights dashboard from which you downloaded it. To do this, they must open the HTML file in an editor and update the 'href' (located between the <a> tags) with the URL for the dashboard from which the download originated.
For example, if you downloaded data from a chart on the Overview dashboard in an HTML export format, the code in the export...
<a href='/explore/lever_reporting/opportunity_progress_events_dash? target='_self'>
0
</a>
...would have to be updated to:
<a href='https://hire.lever.co/visual-insights/overview' target='_self'>
0
</a>