R-Visualizations problem in SAC - library formattable

[korabme]

Hello!

I am trying to reproduce the coding example of https://www.magesblog.com/post/2016-01-19-formatting-table-output-in-r/.

The visualization problem which occurs when running the code is, that the formatting of the "arrow-up" and "arrow-down" icons isn't working. Basically the R-Interface of SAP Analytics Cloud should support the library formattable but for some reasons the visualization of the icons is not supported.

Do you have any suggestions?

See visualization and code below:

library(formattable)
DF <- data.frame(Ticker=c("", "", "", "IBM", "AAPL", "MSFT"),
                 Name=c("Dow Jones", "S&P 500", "Technology", 
                        "IBM", "Apple", "Microsoft"),
                 Value=accounting(c(15988.08, 1880.33, NA, 
                                    130.00, 97.05, 50.99)),
                 Change=percent(c(-0.0239, -0.0216, 0.021, 
                                  -0.0219, -0.0248, -0.0399)))
DF

formattable(DF, list(
  Name=formatter(
    "span",
    style = x ~ ifelse(x == "Technology", 
                       style(font.weight = "bold"), NA)),
  Value = color_tile("white", "orange"),
  Change = formatter(
    "span",
    style = x ~ style(color = ifelse(x < 0 , "red", "green")),
    x ~ icontext(ifelse(x < 0, "arrow-down", "arrow-up"), x)))
)

[mfoeken · Accepted solution]

Hi Korab,

The first thing you should check is whether the library used in the code is supported by SAP Analytics Cloud (R Packages for SAP Analytics Cloud). Only a subset of libraries is included in the R-server environment and I don't see formattable on the list. An alternative is to look for another, supported, library to write your code. Another option is to set up your own R-server (which must be internet-facing).

More information can be found here: 2547708 - How to install additional packages on the R-server in SAP Analytics Cloud.

Kind regards,

Martijn van Foeken | Interdobs

[korabme · Accepted solution]

My bad! The library is not supported by SAC! I was running "INSTALLED PACKAGES" in the console and the "formattable" was listed there. That's why I thought it is already supported. Thanks for the reminder. I have to find an alternative displaying the arrows in the table.

[Vitaliy-R]

Are you using SAP-provided R server runtime environment? If so, then I do not see `formattable` at the list of pre-installed packages: https://blogs.sap.com/2020/03/18/r-packages-for-sap-analytics-cloud/

Regards,
-Vitaliy

[korabme]

Thank you for your support!