Window Calculations

• Oct 21, 2019
• 2 minutes to read

Window calculations compute values for data rows within a window defined by certain criteria.

• Window Calculations Overview
• How to Use Window Calculations

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.

  Expression: RunningSum(Sum([Sales]))

  

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

  Expression: WindowSum(Sum([Sales]), -1, 1)

  

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

  Expression: Sum([Sales]) - Lookup(Sum([Sales]), -1)

  

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

  Expression: Sum([Sales])) / Total(Sum([Sales]))

  

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

  Expression: RankCompetition(Sum([Sales]), ‘asc’)

  

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.

How to Use Window Calculations

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

• WinForms Designer - Using Window Calculations
• Web Dashboard - Using Window Calculations