DifferenceCalculation Class
In This Article
A difference calculation that is used to compute the difference between measure values across a window.
Namespace: DevExpress.DashboardCommon
Assembly: DevExpress.Dashboard.v24.2.Core.dll
NuGet Package: DevExpress.Dashboard.Core
#Declaration
#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.
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);
}
#Inheritance
Object
DevExpress.DashboardCommon.Native.ClonableModelBase<MeasureCalculation>
MeasureCalculation
DevExpress.DashboardCommon.Native.BaseCalculation<DifferenceCalculation>
DifferenceCalculation
See Also