Summarization

<< Click to Display Table of Contents >>

Navigation:  Dashboards > data-shaping >

Summarization

Previous pageReturn to chapter overviewNext page

 

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

Charts_DataBinding_Values

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

The following sections are available.

Summary Function Types

Changing Summary Type

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.

Count Distinct - The number of distinct values.

Sum - The sum of the values.

func_sum

Min - The smallest value.

Max - The largest value.

Average - The average of the values.

func_average

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

func_stddev

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

func_stddevp

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

func_var

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

func_varp

Median - The median of the values (excluding Null and DBNull values). A median is the number separating the higher half of a value range from the lower half.

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.

DataShaping_SummaryTypeMenu