Aggregation

Aggregation can be used to show measures aggregated next to items in the hierarchy tree to have a quick overview of underlaying data. In the image below, aggregation is used to show the sum of all product sales next te each Sub-category in the superstore sample data.

To enable this feature, first drag the desired measure or dimension to aggregate on onto the details mark in the datasheet. Secondly, go to the "Formatting" tab in the "Options" page in the configuration, where you need to select the column/level you want to apply aggregation on.

After which, you need to select on what measure you want to aggregate on. in the example, we used the sales measure. Right next to the measure selection, you need to specify what type of aggregation should be used to combine multiple values.

The number formatting options can be used to customize the decimal point and possible suffix and prefix. Using the percentage number format option automatically calculates the value of the measure time 100. In out example, we used the $ prefix for the sum of sales.

Clicking submit will show the selected aggregation in the hierarchy tree.

Bar charts

The bar chart option can be selected to quickly compare different items in the tree based on their aggregation.

Enable the "Bar chart" checkbox in the Formatting tab to enable this option.

The ranges are automatically set to the minimum and maximum value of all aggregated numbers in the same level, but these can be adjusted. The bar chart coloring can be used to better differentiate different values based on predefined bounds.

Lastly, the gradient option can be used to color the bar charts in a color range from the lowest to the highest number in the set.