Summarization


You are here: InLoox Support Knowledge Base Online Help InLoox for Outlook 10.0 All support articles | InLoox 10 for Outlook Dashboard view Designing dashboards Data shaping Summarization

To obtain numeric values that should be displayed within a dashboard item, Dashboard calculates a summary function against the specified measure.

This topic describes how to specify which summary function should be calculated against a particular measure.

Summary function types

The following summary functions are available.

Count

The number of values (excluding Null and DBNull values).

This is the only summary type that can be calculated against non-numeric data.

Sum

The sum of the values.

Min

The smallest value.

Max

The largest value.

Average

The average of the values.

StdDev

An estimate of the standard deviation of a population, where the sample is a subset of the entire population.

StdDevP

The standard deviation of a population, where the population is the entire data to be summarized.

Var

An estimate of the variance of a population, where the sample is a subset of the entire population.

VarP

The variance of a population, where the population is the entire data to be summarized.

Changing summary type

By default, Dashboard calculates Sum for numeric measures and Count for measures that contain another type of data.

You can change the summary function type for numeric measures. To do this in the Designer, invoke the data item menu and select the desired summary type. Less common summary types are organized in the More submenu.