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.

 Reference Line in SAP Lumira Designer

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)

sample data - variable reference bands in SAP Lumira Designer

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.

Reference bands VBX Property sheet

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.

Reference bands VBX Property sheet

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

SAP Lumira Designer-Reference bands VBX Property sheet

 

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.

SAP Lumira Designer-Reference bands VBX Property sheet

 

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)

 

Step 5: Navigate to the CSS tab and paste the following piece of code in Theme code box. Don’t forget to enable the Custom Theme property

 

SAP Lumira Designer -Visual Bi extensions (VBX) Custom Theme property

Step 6: Navigate to the legends tab and disable the legends

 SAP Lumira Designer -Visual Bi extensions (VBX) Legend property

 

Step 7: Navigate to the Title and Subtitle Tab and set the following properties:

  • Title / Subtitle Text
  • Horizontal Alignment (center as seen below)

SAP Lumira Designer -Visual Bi extensions (VBX) Title property

SAP Lumira Designer -Visual Bi extensions (VBX) Sub title property

 

Step 8: Lastly Set the X axis property as follows:

  • Label rotation (-45 in the example below)
  • If needed, X and Y offset for better label alignment

SAP Lumira Designer -Visual Bi extensions (VBX) X axis property

 

Finally, we have a variable reference line displaying stock information.

Visual BI extensions, VBX, SAP Lumira Designer, SAP Design Studio

Additional useful references,

Importance of Reference lines and Bands

Implementing Reference Lines in SAP Lumira Designer

Click here to download a FREE 15-day trial of Visual BI Extensions for SAP BusinessObjects Design Studio/SAP Lumira Designer.

Subscribe to our Newsletter

5920 Windhaven Pkwy
Plano TX 75093.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com