Summarization

• May 29, 2019

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.

Note

Note that summary type changing is not supported in OLAP mode.

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.

To specify the summary type in code, use the Measure.SummaryType property.

The following code snippet shows how to create a new measure with the SummaryType.Max summary type.

C#

Measure amountMeasure = new Measure("Amount", SummaryType.Max);

VB.NET

Dim amountMeasure As New Measure("Amount", SummaryType.Max)