Implementing Reference Bands in SAP Lumira Designer – Part 2 VBX Product Extensions

In the earlier blog we looked at Implementing Reference Bands having fixed limits in SAP Lumira Designer

Now let’s look at creating Reference bands for Variable Limits.

Implementing Variable Limits Reference Band in a chart

Sample Data

Consider the following sample data, which lists Amazon Stock value for last 1 month – High, Low, Actual and the variance (difference between the highs and the lows)

To create a variable plot band, we would be using the VBX Dual Axis chart as it gives us the flexible to choose the data series type. (Area, Line, Stacked charts……)

Step 1: Drag the VBX Dual Axis chart and select the required data for the chart in the chart properties.

Click on Data Selection and select the following Measure columns – Variance, Low, Actual.

Please note: The order of the measures is important to configure this use case.

Step 2: Navigate to the additional property sheet and select Data Series Tab

Set the series colors for each of the measures (Variance = light grey, Low = white and Actual = orange)
Set the Series Type for each of the measures:
1. Variance = Area Spline Stacked
2. Low = Area Spline Stacked
3. Actual = Spline

Step 3: Configure the other series properties

Set the Series Y axis as 1 for all the measures
Rename the Variance measure as ‘High’. This would be handy to configure the tooltip information later.

Step 4: Configure the marker properties

Enable the Apply Marker Customization property by checking it
Disable the Markers for both measures – High and Low
Enable the Marker for Actual Measure
Set the color and size of the marker (Color = Orange and Size = 4 as seen below)