Tree map allows you to visualize large data using its proportional shelves and color scales.
Figure: Default Tree map visualization showing country wise stocks count.
Figure: Tree map visualization after various customizations.
NOTE: Before adding the Treemap widget to the design layout, make sure to create the data source. You can refer to this section to learn how to create a new data source.
IMPORTANT: To showcase a tree map, a minimum requirement of one value and one group by field is needed.
The following steps explains data configuration of tree map.
Drag and drop the Tree Map control icon from the tool box into design panel. You can find the control in tool box by search.
Resize the widget as required.
Properties icon in the
properties panel of the widget will be displayed as shown in the following screenshot. Now, switch to the
ASSIGN DATA tab.
The data tab will be opened with the available columns from the connected data source.
Bind column by dragging and dropping element from sections to
Drag and drop the elements from sections to
You can configure the
tooltip section to showcase the additional information in the widget’s tooltip without affecting the visualization. Refer to this section for more details on configuring the tooltip fields.
sort the data displayed in the widget from the settings menu options. To open the
settings menu, click the
The following screenshots shows the various settings menu options based on the type of field configured in the type of section.
You can change the aggregation type of the measure section from the settings menu as shown in the following screenshot.
Refer to this section for more details.
You can format the elements by selecting the
Format option. For more details, refer to measure format.
The configured field names can be edited by using the
Rename option provided in the settings menu.
Click the Settings menu icon and select the Rename menu option.
The column name will become editable now. Enter the required text and press
Now, the changes will be reflected in the tree map widget’s
tooltip and in the
legend (if Show legend option is enabled in the properties tab).
You can format the tree map for better illustration of the view that you require, using the settings available in
This allows you to set
title for this tree map widget.
This allows you to set
subtitle for this tree map widget. It is optional.
This allows you to set brief explanation about this grid widget. It is optional.
This allows you to toggle the visibility of legend.
This allows you to select the color for the tree map label. The default value is
In case of hierarchical view, multiple levels will get rendered in the same view. This option will be visible, if you bind more than one column in the Columns section. This can be switched to drill down view by enabling this setting.
To configure linking to URL or dashboard with the widget using its settings. For more details, refer to Linking.
This allows you to configure a single-color palette whose saturation will be varied based on the value density. The default value is
Select Advance setting to configure conditions and apply color to the cells based on that. Click here for more details.
This allows you to define this tree map widget as a master widget such that its filter action can be made to listen by other widgets in the dashboard.
This allows you to define this tree map widget to ignore responding to the filter actions applied on other widgets in dashboard.
Using this option, you can enable or disable hierarchical top N filtering. While applying top N filter with multiple dimension columns, the data returned can be customized based on whether the filtering need to be done as flat or based on the hierarchy of dimension columns added.
When Hierarchical Filter option is enabled, the top N will be applied for each individual column separately based on the number set for each column.
This allows you to customize the widget container appearance, widget title’s properties and provides options to enable/ disable widget exporting options. For more detailed information, refer to container appearance properties.
In case, if you have the requirement to highlight any data based on some conditions, you might be required to enable the advanced formatting option.
In the properties pane, under the Formatting section, click the Advanced Setting radio button.
This will open the Conditional Formatting dialog.
Select the mode and enter the conditions as required and click the Save button to apply.
Now, the widget visualization will be updated based on the conditions.
You can customize the fill color of the tree map using the gradient based conditional formatting. This is the default mode.
You can choose any field from the Based-On section to apply the conditions from the drop-down.
You can select the summary type for the selected measure field.
You can define your range by entering the low, mid, and high values.
NOTE: It is optional, if no value is entered, then the ranges will be auto calculated based on the minimum and maximum values from the data source.
You can enter the title for the tree map legends.
If the region of tree map value is out of the specified range,then the color specified in the default color will be applied.
This allows you to customize the fill color of the tree map based on one or more numerical / text conditions.
The value type drop-down allows you to choose whether to apply the direct value (specific number such as three goals, order ID 10248) or percentage (values above 30% or 50 %).
You can give a meaningful name to the applied conditions.
Choose the condition for measure field from the highlighted conditions.
If you selected the dimension as a based-on field and want to use text condition, the following text-based conditions are available.
NOTE: The text-based condition type will be enabled only when the dimension selected is used as the based-on field.
You can mention the condition value.
For the dimensions, the case sensitive option is provided to choose whether the entered value is case sensitive or not.
Select the fill color for that condition using the color picker.
add condition to specify add new condition.
delete button to remove the existing condition.
individual mode, you can specify a color for each record.
IMPORTANT: Only top 100 records will be listed in the dialog.
You can choose a color for the record from the nearby color picker.
To undo all the changes, click