[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Collapse]Dashboard
 [Expand]Getting Started
 [Expand]Basic Concepts and Terminology
 [Expand]Common Features
 [Expand]Creating the Designer and Viewer Applications
 [Collapse]Creating Dashboards
  [Expand]Creating Dashboards in the WinForms Designer
  [Collapse]Creating Dashboards on the Web
    Creating a Dashboard
   [Expand]Providing Data
    Adding Dashboard Items
   [Expand]Binding Dashboard Items to Data
   [Expand]Designing Dashboard Items
   [Expand]Data Shaping
   [Expand]Interactivity
   [Expand]Appearance Customization
   [Collapse]Data Analysis
     Aggregations
     Window Calculations
    [Expand]Dashboard Parameters
    Converting Dashboard Items
   [Expand]Dashboard Layout
    Undo and Redo Operations
    Saving a Dashboard
    Opening a Dashboard
    Exporting
  [Expand]Creating Dashboards in the Visual Studio Designer
 [Expand]Visual Studio Integration
  End-User Documentation
  Localization
 [Expand]Redistribution and Deployment
  Video Tutorials
 [Expand]Examples
 [Expand]Member Tables
 [Expand]API Reference
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Aggregations

The Web Dashboard control allows you to prepare underlying data using additional aggregation levels when creating Calculated Fields. This topic shows how to evaluate calculated fields on a visualization (summary) and intermediate levels.

Expanded Summary Level Aggregations

To compute values of the calculated field on a visualization (or summary) level, you can use a set of predefined aggregate functions. In the Expression Editor, these functions are available within the Functions | Aggregate.

Function

Description

Example

Aggr(SummaryExpression, Dimensions)

Aggregates underlying data using the detail level specified by a predefined set of dimensions and a specified summary function.

To learn more, see Intermediate Level Aggregations.

Aggr(Sum([Sales]), [Category], [Product])

Avg(Value)

Returns the average of all the values in the expression.

Avg([Profit])

Count()

Returns the number of values.

Count()

CountNotNull(Value)

Returns a number of non-null objects in a collection.

CountNotNull([Orders])

CountDistinct(Value)

Returns the number of distinct values.

CountDistinct([Orders])

Max(Value)

Returns the maximum value across all records.

Max([Profit])

Min(Value)

Returns the minimum value across all records.

Min([Profit])

Mode(Value)

Returns the mode of the values.

Mode([Profit])

Median(Value)

Returns the median of the values.

Median([Profit])

Sum(Value)

Returns the sum of all values.

Sum([Profit])

Var(Value)

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

Var([Orders])

Varp(Value)

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

Varp([Orders])

StdDev(Value)

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

StdDev([Orders])

StdDevp(Value)

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

StdDevp([Orders])

These functions can be used for all types of numeric fields. After creating such calculated fields, you can use them as measures contained in an OLAP cube.

Expanded Intermediate Level Aggregations

The Web Dashboard can aggregate and summarize data on different levels.

  • The Query Builder allows you to prepare an underlying data source before analyzing data. You can apply grouping, sorting, summarization and other data shaping operations during data selection.
  • Dashboard items aggregate and summarize data at a visualization level using dimensions and measures, respectively. To learn more, see Binding Dashboard Items to Data in the Web Dashboard's UI.
  • The Aggr function introduces an intermediate detail level that is not related to the visualization level. This allows you to create custom aggregations at different levels and combine these aggregations with existing visualizations.

To learn how to use the Aggr function, see Intermediate Level Aggregations.

Is this topic helpful?​​​​​​​