We are updating the DevExpress product documentation website and this page is part of our new experience. During this transition period, product documentation remains available in our previous format at documentation.devexpress.com. Learn More...
V
18.1
18.2 (CTP)
18.1
17.2
All docs
General Information
.NET Subscription
Desktop
Web
Code / Debug / Refactor
Frameworks and Libraries
IOS, Android & Xamarin
All docs
V18.1
General Information
.NET Subscription
Desktop
Web
Code / Debug / Refactor
Frameworks and Libraries
IOS, Android & Xamarin
18.2 (CTP)
18.1
17.2
Measure.Calculation Property
Gets or sets a calculation applied to values of the current measure.
Namespace: DevExpress.DashboardCommon
Assembly: DevExpress.Dashboard.v18.1.Core.dll
Declaration
public MeasureCalculation Calculation { get; set; }Public Property Calculation As MeasureCalculationProperty Value
| Type | Description |
|---|---|
| MeasureCalculation | A MeasureCalculation descendant that specifies a calculation applied to values of the current measure. |
To apply a calculation to values of the required measure, perform the following steps.
- Create the MeasureCalculation class instance, initialize its settings and assign the resulting object to the Calculation property. As an alternative, you can specify a calculation by adding the required calculation functions inside the measure expression (Measure.Expression).
- Specify a window used to apply a calculation. To do this, create and initialize the required descendant of the MeasureCalculationWindowDefinition class (depending on the type of the target dashboard item) and assign the resulting object to the Measure.WindowDefinition property.
To learn more, see Window Calculations.
Examples
The code snippet below shows how to create the RunningTotalCalculation for the Extended Price measure. The calculation is performed along columns of the Pivot dashboard item.
// ...
Measure extendedPrice = new Measure("Extended Price");
PivotWindowDefinition pivotWindowDefinition = new PivotWindowDefinition();
pivotWindowDefinition.DefinitionMode = PivotWindowDefinitionMode.Columns;
extendedPrice.WindowDefinition = pivotWindowDefinition;
RunningTotalCalculation runningSum = new RunningTotalCalculation();
runningSum.SummaryType = SummaryType.Sum;
extendedPrice.Calculation = runningSum;
' ...
Dim extendedPrice As New Measure("Extended Price")
Dim pivotWindowDefinition As New PivotWindowDefinition()
pivotWindowDefinition.DefinitionMode = PivotWindowDefinitionMode.Columns
extendedPrice.WindowDefinition = pivotWindowDefinition
Dim runningSum As New RunningTotalCalculation()
runningSum.SummaryType = SummaryType.Sum
extendedPrice.Calculation = runningSum
See Also
give feedback
Was this topic helpful?
Did it help answer your question?
Did it help answer your question?