DifferenceCalculation Class

A difference calculation that is used to compute the difference between measure values across a window.

Namespace: DevExpress.DashboardCommon

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

NuGet Packages: DevExpress.Dashboard.Core, DevExpress.Win.Dashboard.Design

Declaration

C#

public class DifferenceCalculation :
    BaseCalculation<DifferenceCalculation>

VB.NET

Public Class DifferenceCalculation
    Inherits BaseCalculation(Of DifferenceCalculation)

Remarks

To apply a calculation to values of the required measure, perform the following steps.

• Create the DifferenceCalculation class instance, initialize its settings and assign the resulting object to the Measure.Calculation property. As an alternative, you can create a calculation expression with the calculation functions and assign it to the (Measure.Expression property.
• Specify a window used to apply a calculation. To do this, create and initialize the descendant of the MeasureCalculationWindowDefinition class (choose the descendant related to the dashboard item type) and assign the resulting object to the Measure.WindowDefinition property.

Example

The code snippet adds a new measure to the Pivot dashboard item and specifies a window calculation to compute the difference between measure values across a window. The calculation is performed along columns of the Pivot dashboard item.

C#

using DevExpress.DashboardCommon;
using DevExpress.DashboardWin;
// ...
PivotDashboardItem pivotItem = dashboardViewer1.Dashboard.Items[pivotItemName] as PivotDashboardItem;
if (pivotItem != null)
{
    Measure extendedPrice = new Measure("Extended Price")
    {
        Name = "Diff",
        ShowGrandTotals = false
    };
    PivotWindowDefinition pivotWindowDefinition = new PivotWindowDefinition();
    pivotWindowDefinition.DefinitionMode = PivotWindowDefinitionMode.Columns;
    extendedPrice.WindowDefinition = pivotWindowDefinition;
    extendedPrice.Calculation = new DifferenceCalculation() { DifferenceType = DifferenceType.Absolute };
    pivotItem.Values.Add(extendedPrice);
}

VB.NET

Imports DevExpress.DashboardCommon
Imports DevExpress.DashboardWin
' ...
Dim pivotItem As PivotDashboardItem = TryCast(dashboardViewer1.Dashboard.Items(pivotItemName), PivotDashboardItem)
If pivotItem IsNot Nothing Then
    Dim extendedPrice As New Measure("Extended Price") With { _
        .Name = "Diff", _
        .ShowGrandTotals = False _
    }
    Dim pivotWindowDefinition As New PivotWindowDefinition()
    pivotWindowDefinition.DefinitionMode = PivotWindowDefinitionMode.Columns
    extendedPrice.WindowDefinition = pivotWindowDefinition
    extendedPrice.Calculation = New DifferenceCalculation() With {.DifferenceType = DifferenceType.Absolute}
    pivotItem.Values.Add(extendedPrice)
End If

Inheritance

Object

DevExpress.DashboardCommon.Native.ClonableModelBase<MeasureCalculation>

MeasureCalculation

DevExpress.DashboardCommon.Native.BaseCalculation<DifferenceCalculation>

DifferenceCalculation