Hello,
if the argument ticksuffix = " €"
and/or the argument separators = ","
the hover text for the total
measure category shows NaN
.
x= list("Sales", "Consulting", "Net revenue", "Purchases", "Other expenses", "Profit before tax")
measure= c("relative", "relative", "total", "relative", "relative", "total")
text= c("+60", "+80", "", "-40", "-20", "Total")
y= c(60, 80, 0, -40, -20, 0)
data = data.frame(x=factor(x,levels=x),measure,text,y)
p <- plot_ly(
data, name = "20", type = "waterfall", measure = ~measure,
x = ~x, textposition = "outside", y= ~y, text =~text,
connector = list(line = list(color= "rgb(63, 63, 63)"))) %>%
layout(title = "Profit and loss statement 2018",
xaxis = list(title = ""),
yaxis = list(title = "", ticksuffix = " €"),
autosize = TRUE,
showlegend = TRUE)
Edit
This and some other NaN
generators for the totals
are solved in the dev version 4.9.0.9000