A tree map shows hierarchical data as nested rectangles. The size of each rectangle is proportional to the measure of the data it represents. Users can click on a parent rectangle to drill through to the nest rectangles. Tree maps are a compact way of showing tree data and can help you see patterns in your data that are difficult to see in other ways.
This example shows a tree map for three levels of data: country, region, and city. The dialog shown is this example is used for TreeMap and OneParentTreeMap.
Creating a Tree Map
To create the report for the chart:
| 1. | Create a new, blank report using the Sample DB data adapter and the query: select * from orders order by shipcountry. |
| 3. | Click  |
| 4. | Delete all bands except for Title and Summary. |
| 5. | Enlarge the Summary band to 500 pixels by changing the Height entry in the Band Properties view. |
To create the chart:
| 1. | Click |
The HTML5 Chart Edit Dialog is displayed.
| 2. | Select your chart type. For this example, select TreeMap. |
| 3. | Click the Data Configuration tab. |
The HTML5 Chart Edit dialog is displayed.
| 4. | Click |
The Categories dialog opens.
| |
| Defining Multiple Categories in a Chart |
| 5. | Select Category 1 and click Modify. |
The Expression Editor is displayed.
| 6. | Enter your highest level of data for Category 1 then click Finish. For this example, enter
$F{SHIPCOUNTRY}. |
| 7. | Click Add in the Categories dialog box, enter $F{SHIPREGION}, and click Finish. |
| 8. | Click Add in the Categories dialog box, enter $F{SHIPCITY}, and click Finish. |
| 9. | When you have created all your levels, click OK to return to the HTML5 Chart Edit Dialog. |
| 10. | Enter the following to create the measure: |
| • | Value Expression – $F{FREIGHT}.doubleValue() |
| • | Aggregation Function – Sum |
| • | Tooltip Expression - "Total Freight" |
| 11. | Click OK, and save and preview the chart as HTML. |
Using Advanced Formatting Properties
When you preview the chart as HTML, you can click on a rectangle to zoom in. However, you can see some problems with the chart view.
| |
| Tree Map After Drill Through, Showing Formatting Issues |
| • | When a country, such as USA, is selected, the adjacent country is shown on the chart. |
| • | The label to return to a higher level reads undefined. |
You can use advanced formatting to set these properties. For more information about advanced formatting, see Advanced Formatting of HTML5 Charts
To set advanced properties for the chart:
| 1. | Return to Design view and double-click the chart to open the HTML5 Chart Edit dialog. |
| 2. | Click the Chart Formatting tab and click Show Advanced Properties. |
| |
| Advanced Formatting Properties |
| 4. | The Chart Property dialog is displayed. |
| |
| Setting Advanced Chart Formatting |
| 5. | To prevent the names of other countries from showing on the border of the charts, enter the following, then click OK: |
| • | Property name – plotOptions.treemap.dataLabels.overflow |
| 6. | To change the text of the button, click Add, enter the following, then click OK: |
| • | Property name – plotOptions.treemap.drillUpButton.text |
| 7. | Click OK to apply your properties and return to Design view. |
Preview the chart in HTML to drill through and see your changes.
| |
| Tree map after formatting issues have been corrected |
| | Static Highcharts properties are always recognized as String. If you have problems setting a static Boolean or numeric property, set it as an expression. For example, to set plotOptions.series.dataLabels.enabled to false, use the following JRXML: |
Recommended Comments
There are no comments to display.