Pie Chart using R visualization in SAP Analytics Cloud

tharunbalaji — Mon, 09 Dec 2024 03:46:48 GMT

Hi,

In SAP Analytics Cloud, traditional charts are highly effective for most use cases. However, there are times when we need to push the boundaries and create something truly unique. This is where custom R visualizations come into play, offering a powerful way to go beyond standard capabilities.

Our goal was straightforward: we wanted to create a clean, interactive pie chart without the traditional lines pointing to the values, while also enhancing the overall presentation.

In this blog, we’ll walk you through the process of designing an interactive pie chart using R visualizations in SAP Analytics Cloud

Step 1: Creating a Widget

Click on Insert->Others -> R visualization

Step 2: Choosing the model

Click on ‘Add Input data’ on the right pane and choose the model which you are going to build and the corresponding measures and dimensions and click on Ok Button.

Step 3: Writing the R Script

Click on ‘add script’ and you will get the below window where you can write your R scripts

Step 4: Scripting using R

Write the scripts, click on 'Execute' button to preview and finally click apply

library(plotly)

library(dplyr)

# Create the data frame

df = data.frame(

product = MD_Test_Model$’Dimension 1’,

val1 = MD_Test_Mode$’Test Calculation’)

Note: After typing the model followed by $, when you press ‘Ctrl’ + Space, it lets you to choose the respective dimension/measure

# Summarize

df <- df %>%

group_by(product) %>%

summarise(val1 = sum(val1)) %>%

arrange(desc(val1)) %>%

mutate(percentage = val1 / sum(val1) * 100) # Calculate percentage for hover info

# Define custom colors for the pie chart

custom_colors <- c(

"#1f77b4", "#ff7f0e", "#2ca02c", "#d62728", "#9467bd",

"#8c564b", "#e377c2", "#7f7f7f", "#bcbd22", "#17becf")

# Creating the pie chart

plot_ly(df, labels = ~product, values = ~val1, type = 'pie',

textinfo = 'percent', # Shows percentages on the pie slices

hoverinfo = 'text', # Customizes hover information

text = ~paste("Value: ", val1, "<br>", "Percentage: ", round(percentage, 1), "%"), # Hover text

marker = list(colors = custom_colors) # Applies custom colors

) %>%

layout(title = "Title",

margin=list(l=10,r=30,t=30,b=10),

legend = list(

orientation = "h", # Places the legend horizontally

x = 0.5,y=1.45, xanchor = "center", # Centers the legend

font = list(size = 8 # Adjusts font size of the legend

)

The Pie Chart is Created

Re: Pie Chart using R visualization in SAP Analytics Cloud

RajuRam — Fri, 19 Sep 2025 14:59:06 GMT

Hi,

Thank you for sharing your work and the nice example with R-Visualization, especially the Pie Chart. It is always good to see such creative use of SAC features. Just a small note: this type of detailed write-up will get better visibility if published in the Blog section rather than Q&A, since blogs are the right place for such informative content. Appreciate your contribution and looking forward to more such posts.

Question Re: Pie Chart using R visualization in SAP Analytics Cloud in Technology Q&A

Pie Chart using R visualization in SAP Analytics Cloud

Re: Pie Chart using R visualization in SAP Analytics Cloud