You can set up links off of your reports to navigate to a different URL or into a different report when you click on a report element. To get started, click on the field in the report that you wish to link from and choose 'Edit this Field'. From the field edit window, click on the 'Add links to URLs or other reports' as shown below:
You can link back to actionable information from your Easy Insight reports by defining URL links. For example, you might want to be able to click back to the project screen on a project management system, or to a deal detail screen on a CRM system. Click on the Create Link button and choose 'URL' as the link type.
Generally, you'll want to reference one or more fields from your data to create that URL. You'll want to use the same bracket notation used in scripting to reference those fields and build the URL. For example, you might be passing back to a specific page referenced through the Opportunity ID in the URL, you'd have your URL with [Opportunity ID] in it as shown below:
Drillthroughs enable you to connect your reports and dashboards together. Open up the field edit window (click on the field in the report and chooes Edit Field Properties... from the drop down) and click to the Links tab. Click on Create a Link and change the selection to Drillthrough.
First, choose whether the drillthrough will go to a report or dashboard, and choose the report or dashboard you'll link to. Typically, drillthroughs are used to go from higher level to lower level information. For example, a chart of project summary information might link into the detailed todo information underlying that summary information. In such a scenario, you'd define the drillthrough on the Project Name field in the summary report, and choose a drillthrough table of Todo Table or some other list report containing the detailed information. The drillthrough will automatically create a filter on what you're clicking on, if possible. For example, in our above scenario, clicking on a particular project name will automatically create a filter on Project Name in the target report.
You have several options for customizing drillthrough behavior:
You can also configure drillthroughs at the data source level so that you don't have to recreate configuration for each report. For more information, see Data Source Drillthroughs.
Especially in list reports, you might find that you have certain fields you don't want to include in a drillthrough. For example, in a forecasting report, you might have a variety of date fields, purchase fields, and more, while you really want the drillthrough to only operate off of the SKU in the row:
To set up drillthrough field exclusions, click on Custom Field -> Manage Report Fields from the report editor:
Toggle the 'Skip on Drillthrough' toggle at the top of the window, then toggle off the fields you want excluded by default from drillthroughs:
You can use this option to easily create more dynamic drillthrough reports. For example, we can start with the following trend report:
Using the Add Field to Target Report option, we can create a dynamic drillthrough to show month over month history. First, we'll create a column chart using Deal Size as the starting point:
From there, we can return to our trend report and set up the same drillthrough on all three fields, checking the Add Field to Target Report option:
Once configured, the column chart automatically updates to the appropriate measure when we click on the trend number:
You can use this option in conjunction with the following reports as the drillthrough target:
