Creation of Increment and Decrement Indicator Arrow in SAP Analytics Cloud using R Visualization

R Visualization in SAP Analytics Cloud can be used to create charts which are not directly available in SAP Analytics Cloud. In this blog I am explaining how to create an Increment and Decrement Indicator Arrow in SAP Analytics Cloud using R Visualization feature.

Step-1: Either create a new Story or open an existing story in edit mode. Navigate to “Insert” and click on “+” button. Click on “R Visualization”.

Step-2: Add the Model as Input Data in Builder.

Step-3: Click on “Add Script” in Builder.

Step-4: Expand the window.

Step-5: There are 4 panes in the window i.e. Editor, Environment, Console and Preview.

The R code is written in the Editor and then executed. Any error message is displayed in Console. If no errors, the visualization is displayed in Preview.

With R, many plotting symbols are available which can be be used using the graphical argument ‘PCH‘

Below is the list of available plotting symbols.

The other arguments required to customize the symbols are as below.

col: Color to be used for points

bg: The background or Fill color for open plot symbols. It can be used only when pch = 21:25

cex: The size for pch symbols

lwd: The line width for the plotting symbols.

R Code for Increment/Decrement Indicator:

x<-c(1)

data1<-Sample_Model$`Profit 2020`

plot(x,xaxt=’n’,yaxt=’n’,

frame.plot=FALSE,ann=FALSE,

pch=ifelse(data1>=Sample_Model$`Profit 2019`,24,25),cex=20,

col=ifelse(data1>=Sample_Model$`Profit 2019`,”green”,”red”),

bg=ifelse(data1>=Sample_Model$`Profit 2019`,”green”,”red”),lwd=1)

Step-6: After submitting the code, the indicator is included in the story.

Usage:

The indicators can be further customized by including variance values as shown below. This helps provide more insight to the underlying data to the end users.

In similar ways, changing the pch values other indicators can be included in the SAC story.

Technical inputs shared by @Suvam Dey

References : http://www.sthda.com/english/wiki/r-plot-pch-symbols-the-different-point-shapes-available-in-r