是否可以使用其他显示值(即用于确定color_bar大小的值以外的值)填充格式表color_bar
在下表中,我想使用以下ttl显示值覆盖这些值:
c(1000,1230,1239,1222,1300,1323,1221)
library(tidyverse)
library(knitr)
library(kableExtra)
library(formattable)
tchart <- data.frame(id = 1:7,Student = c("Billy","Jane","Lawrence","Thomas","Clyde","Elizabeth","Billy Jean"),grade3 = c(55,70,75,64,62,55,76),ttl = c(105,120,125,114,112,105,126),avg =c(52.31,53.0,54.2,51.9,52.0,52.7,53.0))
tchart %>%
mutate(id = cell_spec(id,"html",background = "red",color = "white",align = "center")) %>%
mutate(grade3 = color_bar("lightgreen")(grade3)) %>%
mutate(ttl = color_bar("lightgray")(ttl)) %>%
mutate(avg = color_tile("white","red")(avg)) %>%
kable("html",escape = F) %>%
kable_styling("hover",full_width = F) %>%
column_spec(4,width = "4cm")
我检查了文档,没有发现这种可能性,但是我希望有解决方法或自定义函数解决方案。