cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
Color is an extremely useful visualization tool. On a line chart, a color gradient can be used to emphasize the highs and lows. Using the Python / R integration in Sisense for Cloud Data Teams, we can definitely achieve this look.
 
Here's the SQL output for the number of gameplays for a fictional company. 
From here, we apply the following R code to create a line chart where lower values are marked in red and higher values are marked in green.
# SQL output is imported as a dataframe variable called "df"
# Use Sisense for Cloud Data Teams to visualize a dataframe or show text by passing data to periscope.table() or periscope.text() respectively. Show an image by calling periscope.image() after your plot.
library(ggplot2)

output <- ggplot(df, aes(x = date, y = count, color = count )) +
  geom_line(size = 1.5)  +
  scale_colour_gradient2(low = "red", mid = "yellow" , high = "seagreen", midpoint=median(df$count)) +
  theme(legend.position="none")

# make it look like other Sisense for Cloud Data Teams charts
output <- output + scale_y_continuous(expand = c(0, 0))
output <- output +
  theme(panel.background = element_rect(fill = "transparent"),panel.grid.major.x = element_blank(),panel.grid.major.y =element_line(size=.15, color="gray15"),axis.text=element_text(family='NimbusSan',size=12),axis.title.x=element_text(family='NimbusSan',size=14),axis.title.y=element_text(family='NimbusSan',size=14))
output <- output + theme( rect = element_rect(fill = "transparent"))

periscope.image(output)
This generates the above output. Pretty neat, right? 
Rate this article:
Version history
Last update:
‎02-15-2024 02:01 PM
Updated by:
Contributors