Measure.Expression Property

Namespace: DevExpress.DashboardCommon

Assembly: DevExpress.Dashboard.v21.2.Core.dll

Declaration

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

<DefaultValue(Nothing)>
Public Property Expression As String

Property Value

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.

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();

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()