Ad Hoc View – Tree Map
Tree Map charts display data as rectangles; the size of each rectangle is proportional to the measure of the data it represents. The tree map displays nested rectangles when you have more than one field; the parent rectangle represents the leftmost measure while the nested rectangles represent the current level of aggregation. Click on a parent rectangle to drill down to the nest rectangles.
Charts allow you to graphically display your data. There are a number of different chart types available in various ways.
Range charts display values as heat maps.
Step 1. Open or create a new ad hoc view (refer to the Creating Ad Hoc Views article for further information)
Step 2. Select Chart from the drop-down at the top of the screen.
By default, a column chart is selected.
Step 3. To change the chart type, click the options drop down in the top left corner of the chart area.
Step 4. Select Chart Types and select Tree Map chart.
Hover your mouse over the chart thumbnail to see the chart type name.
There are 5 Range charts available:
Each chart type displays your data in slightly different ways.
Heat Maps display individual values as colour
Select Tree Map Chart
The Tree Map chart displays data as colour coded rectangles. The size of the rectangle is proportional to the measure it represents. The Tree Map allows multiple fields to be displayed.
Step 5. Click and drag a measure from the measures area on the left hand side pane to the column area. e.g. Count of Clients
Tip: All charts must have at least one measure.
Step 6. Click and Drag a field to the columns area
e.g. Primary Address City.
This allows the measure data to be broken up by the field information.
The measure is displayed against the selected field.
Step 7. Add an additional field to the rows area. E.g. Gender
You’ll notice when the field is added that the chart may not change.
In the right hand side pane there is a section called Data Level.
The slider allows you to quickly change the level at which the data is reported. When the slider is all the way to the left, it shows the measure total.
Step 8. Slide the slider all the way to the right.
Tip: If you hover your mouse over the left and right ends of the slider the data level options will be displayed. Sometimes there are multiple options along the length of the slider.
The rectangles are now split by the additional measure.
Step 9. Hover your mouse over a rectangle to display the measure information.
Step 10. Click on one of the rectangles to show further information.
Clicking on the rectangle brings that field into full screen and displays information about the second measure.
Step 11. To return to the previous screen, press the back button at the top right.
Step 12. Add an additional field to the chart.
e.g. main source of income
Step 13. Move the slider to the right
The rectangles are broken down further by the added field.
For further information on Ad Hoc Views and Charts, refer to the following articles: