Measure.SummaryType Property

Gets or sets the type of summary function calculated against this Measure.

Namespace: DevExpress.DashboardCommon

Assembly: DevExpress.Dashboard.v23.2.Core.dll

NuGet Package: DevExpress.Dashboard.Core

Declaration

C#

[DefaultValue(SummaryType.Sum)]
public SummaryType SummaryType { get; set; }

VB.NET

<DefaultValue(SummaryType.Sum)>
Public Property SummaryType As SummaryType

Property Value

Type	Default	Description
SummaryType	Sum	A SummaryType enumeration member that specifies the type of summary function calculated against this Measure.

Available values:

Show 12 items

Name	Description
Count	The number of values (excluding Null and DBNull values).
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 all of the 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 all of the data to be summarized.
CountDistinct	The number of distinct values.
Median	The median of the values. A median is the number separating the higher half of a value range from the lower half.
Mode	The mode of the values. A mode is the value that is repeated more often than any other.

Remarks

The Dashboard can calculate different summary functions against measure values. These functions include sum, average, minimum, maximum, standard deviation, etc.

Use the SummaryType property to specify which summary function should be calculated against the current measure.

Note

Changes to the summary type are not supported in OLAP mode.

In server mode, summary functions have the following limitations when the Dashboard uses SQL Data Sources:

• The Count Distinct summary function is not supported for the following database engines:
  • Microsoft Access
  • Microsoft SQL Server CE
• The Median summary function is supported for the Oracle data provider only.
• The Mode summary function is supported for the Oracle and PostgreSQL data providers only.

Example

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)