Combination of iteration and aggregation

If you are using iterations and aggregations combined, the aggregation is run for the subset of values that are part of the iteration step. The two images shown in this chapter illustrate this context.

Of course, you can both combine multiple iterations for different criteria and query multiple aggregations for the same or different criteria.

The rule of thumb is that the value displayed in each iteration step is the same value that is displayed when the iteration is replaced by filters for the step values.

Example

In this example, the iteration using the Host criterion is replaced by the filter Linux. The resulting average value for license costs is 30, as in the iteration.

Average license costs of the applications per host:

s_ppm_da_query_logic_ex5.png

Host leasing rate per application:

s_ppm_da_query_logic_ex6.png