Skip to main content

Measure.SummaryType Property

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

Namespace: DevExpress.DashboardCommon

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

NuGet Package: DevExpress.Dashboard.Core

#Declaration

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

#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.

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 all of the 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 all of the data to be summarized.

func_varp

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.

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