[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
 [Collapse]Common Features
   Supported Data Sources
  [Expand]Connecting to a Data Source
   Data Preparation
   Binding to Data
  [Expand]Data Shaping
  [Expand]Interactivity
  [Expand]Appearance Customization
  [Collapse]Advanced Analytics
    Calculated Fields
    Window Calculations
    Parameters
    Expression Constants, Operators, and Functions
   Dashboard Layout
   Printing and Exporting
 [Expand]Creating the Designer and Viewer Applications
 [Expand]Creating Dashboards
 [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)

Window Calculations

Window calculations provide the capability to apply specific computations to measure values and allow you to perform different analytical tasks such as computing running totals, percentages of totals, differences, etc.

Expanded Window Calculations Overview

The DevExpress Dashboard allows you to apply window calculations to values of the specified measure. The following calculation types are supported.

  • Running Total - Allows you to calculate a cumulative total for a set of measure values.

  • Moving Calculation - Allows you to apply a moving calculation, which uses neighboring values to calculate a total. Note that neighboring values are specified using offsets from the currently processed value.

  • Difference - Allows you to compute differences between measure values.

  • Percent of Total - Allows you to calculate a contribution of individual measure values to a total.

  • Rank - Allows you to rank values of the specified measure.

Note

The dashboard control does not allow sorting by measures with applied Window Calculations since the calculation value can depend on the calculated element position.

Expanded How to Use Window Calculations

The topic below show how to use window calculations in the WinForms Designer and on the web.

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