Aggregation

The aggregation report allows visualizing property values and aggregations of these values in a bar chart. The bars are generated based on the selection of a property and a suitable aggregation function. An optional group criterion can be selected to get a grouped bar chart.

Configuration

Follow the steps to create a new aggregation chart:

1. Use the query bar to create custom queries.
2. Use the Customize bars menu to change the bars.
3. Select a group criterion if splitting the result-set makes it easier to read.
4. Use the Save button on the right to save the configuration of your aggregation chart.
5. A click on a bar opens a new table report that shows the assets behind the aggregated values.

Configuration bars

Multiple bars can be configured within the same aggregation report. For each bar, an aggregation function is applied to the assets resolved by the query.

Each bar is defined by...

• a color,
• an aggregation function,
• and a property (if the aggregation requires one).

Available aggregation functions

Aggregation function	Valid properties	Description
sum	single value numeric properties only	Sums up all values of a numeric property.
minimum	single value numeric properties only	Shows the minimum value of a numeric property or zero if no property has a value.
maximum	single value numeric properties only	Shows the maximum value of a numeric property or zero if no property has a value.
average	single value numeric properties only	Shows the average (arithmetic mean) of all property values where a value is set
median	single value numeric properties only	Shows the median of all property values where a value is set
number of assets	no property needed	Shows/counts the number of assets
number of assets with value	no property needed	Shows/counts the number of assets where the property has a value

The aggregation functions number of assets (with value) are particularly useful in combination with grouping.

Groups

An optional group criterion can be defined to split the result into multiple sections. Each aggregation is then calculated and displayed per group.

Info:

If only a single bar is configured and the query results in only a single group, the raw value is shown instead of rendering a bar chart.

Styling

The aggregation report only shows accumulative data, the styling via conditional styling is, therefore, not available.

Export

The aggregation can be exported as PDF, PNG or SVG file.