|Table of Contents|
Using either the drill down hierarchies or related reports option you can set up drill on charts. This allows users to click on a specific chart section and drill down or through to a related report for more detail. Using this option you can set up charts that drill into more detailed charts or tables, providing users with a greater level of data analysis.
Chart drill functionality inherits the drill parameters of the report. Use the standard drill functions to setup the drill parameters for a report.
Note: Ensure that the report drill through parameters and fields are the same that are used in your chart.
Chart Drill Through Settings
When creating your chart(s) there are a range of options you can apply to enable drill functionality that you have applied to your report.
|Drill Enabled||All||All of the compatible drill through relationships, defined on the Related Reports step of the builder, will be used on this chart.|
|OnOne||Only one of the drill through relationships, defined on the Related Reports step of the builder, will be used on this chart.|
|Enabled Report||(Report List)|
Here you can define which Drill Through report relation is used on the chart. All others will be ignored for this chart.
Note: This option is only available when Drills Enabled is set to One.
|Drill Through Relationship||Automatic||The drill through relationships to be used on this chart will automatically be set up. For this to happen all the join fields defined in each relationship must be a chart component in order for the relationship to link correctly. The defined hyperlink field in the relationship is ignored as the link is automatically applied.|
|Full||The drill through relationships to be used in this report will be set up with whatever link fields are used in the chart, all other defined link fields will be omitted as part of the drill. The hyperlink field will be used as defined in the Related Reports step.|
Below is a table of drill functionality by chart type.
Note: All charts can use Link To drilling.
|Chart Type||Chart||Drill Down||Drill Anywhere||Drill Through|
|Auto Chart||Select Scenarios|
|Box & Whisker|
|Trellis (Select Scenarios)|
|Area (Time Series)|
|Horizontal Bar (Time Series)|
|3D Horizontal Bar|
|Stacked Horizontal Bar|
|Stacked Horizontal Bar (Time Series)|
|Vertical Column (Time Series)|
|3D Vertical Column|
|Stacked Vertical Column|
|Stacked Vertical Column (Time Series)|
|3D Stacked Column|
|Combination Charts||Combined Category|
|Combined Category (Time Series)|
|Overlay Chart (Time Series)|
|Line (Time Series)|
|GIS Google Map|
|GIS Bubble Map|
|GIS Heat Map|
|Digital Numeric Display|