General Information
.NET Subscription
Desktop
Web
Controls and Extensions
Mainteinance Mode
Enterprise and Analytic Tools
Quality Assurance and Productivity
Frameworks and Libraries
General Information
.NET Subscription
Desktop
Web
Controls and Extensions
Mainteinance Mode
Enterprise and Analytic Tools
Quality Assurance and Productivity
Frameworks and Libraries
PivotWindowDefinition Class
A window definition used to perform calculations within the PivotDashboardItem.
Namespace: DevExpress.DashboardCommon
Assembly: DevExpress.Dashboard.v19.2.Core.dll
Declaration
public class PivotWindowDefinition :
MeasureCalculationWindowDefinitionPublic Class PivotWindowDefinition
Inherits MeasureCalculationWindowDefinitionRemarks
A window definition is used to apply calculations to measure values. To specify a window, create and initialize the PivotWindowDefinition class and assign the resulting object to the Measure.WindowDefinition property.
The PivotWindowDefinition class allows you to specify the window for the Pivot dashboard item.
Important
The assignment of a PivotWindowDefinition instance to the MeasureDefinition.WindowDefinition property is required to perform window calculations.
Examples
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);
}
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