Measure.Expression Property

Gets or sets the expression for the current measure.

Namespace: DevExpress.DashboardCommon

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

Declaration

C#

[DefaultValue(null)]
public string Expression { get; set; }

VB.NET

<DefaultValue(Nothing)>
Public Property Expression As String

Property Value

Type	Default	Description
String	*null*	A String that specifies the expression for the current measure.

Remarks

If you want to specify a calculation using the Expression property, 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.

See the Calculation Functions Reference topic to see the descriptions of window functions that can be used to specify measure expressions.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Expression property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-dashboard-window-calculation-example/CS/WindowCalculationExample/Form1.cs#L59

scatterChart.AxisXMeasure.WindowDefinition = new ScatterWindowDefinition();
scatterChart.AxisYMeasure.Expression = "WindowMedian(ToDouble(Sum([Extended Price]) - Lookup(Sum([Extended Price]), -1)) / Lookup(Sum([Extended Price]), -1), 0, 1)";
scatterChart.AxisYMeasure.WindowDefinition = new ScatterWindowDefinition();

VB.NET

winforms-dashboard-window-calculation-example/VB/WindowCalculationExample/Form1.vb#L48

scatterChart.AxisXMeasure.WindowDefinition = New ScatterWindowDefinition()
scatterChart.AxisYMeasure.Expression = "WindowMedian(ToDouble(Sum([Extended Price]) - Lookup(Sum([Extended Price]), -1)) / Lookup(Sum([Extended Price]), -1), 0, 1)"
scatterChart.AxisYMeasure.WindowDefinition = New ScatterWindowDefinition()