Create Hyperlinks on Visualizations
You can add hyperlinks to charts with Pentaho Report Designer. A chart can link to three location types.
Location Type | Description | Generated Link Example |
---|---|---|
Pentaho Repository | Creates a context link on the Pentaho server | http://localhost:8080/pentaho//conte...ditor?command= open&solution=steel-wheels&path=analysis &action=Product%20Line%20Sales% 20Trend.xanayzer&line=Classic%20Cars. |
URL | Creates a link that goes to a defined URL | http://www.myApplication.com/search?...&myLine=Trains. |
Self | Creates a link to a custom-built web application and refers back to itself as a link. This option is rarely used. | N/A |
Link locations depend on the chart type.
Chart Type | Location of Link |
---|---|
Bar | Bars |
Area and line | Markers |
Pie and doughnut | Slices |
Bubble | Bubbles |
In the chart editor, you have several Chart Field options. Depending on the chart type, there are various internal chart fields that can be used by the link and are only available when used within the Edit Chart dialogue box. Go to Formula Editor > Toolbar to see these options.
Chart Field | Descriptions | Chart Type |
---|---|---|
chart:series-key | Returns the series name | Bar, line and area |
chart:series-keys | Returns all the series name | Bar, line and area |
chart:series-index | Returns the series index number starting at 0 | Bar, line and area |
chart:category-key | Returns the category name | Bar, line and area |
chart:category-keys | Returns all category names | Bar, line and area |
chart:category-index | Returns the category index number starting at 0 | Bar, line and area |
chart:value | Returns the numeric value | Bar, line and area |
chart:key | Returns the slice name | Pie and doughnut |
chart:keys | Returns all the slice names | Pie and doughnut |
chart:item | Returns the category name | Pie and doughnut |
chart:items | Returns all category names | Pie and Doughnut |
chart:pie-index | Returns the category index number starting at 0 | Pie and Doughnut |
chart:x-value | Returns the value of x | Scatter and XY |
chart:y-value | Returns the value of y | Scatter and XY |
chart:z-value | Returns the value of z | Scatter and XY |