Why doesn't plotly show the date properly on hover?

Question

i'm creating a dashboard using the shiny package. One of the plots, which is supposed to show the date on hover is not doing so, instead, its displaying a decimal value for the date. Date is saved in the as.Date() function, in the 'date' variable :

custData$date <- as.Date(custData$date, "%m/%d/%Y")

Server.R code for displaying the plot:

output$sidePlot2 <- renderPlotly({print(ggplotly(custData %>% group_by(date) %>% summarise(revenue = sum(lineTotal)) %>% ggplot(aes(x = date, y = revenue)) + geom_line() + geom_smooth(method = 'auto', se = FALSE) + labs(x = 'Date', y = 'Revenue (£)', title = 'Overall Revenue Trend by Date') ) ) } )

May be the date conversion is not right, can you share reproduce your data? — Rana Usman
– Rana Usman, Commented Apr 2, 2018 at 8:29
Try downloading the newest version of ggplot2 with devtools::install_github("tidyverse/ggplot2"). I recently came across a similar issue and resolved it by upgrading from 2.2.1 (the CRAN version) to 2.2.1.9000 — Gregor de Cillia
– Gregor de Cillia, Commented Apr 2, 2018 at 20:18

Prem · Accepted Answer · 2018-04-02 10:47:11Z

I think you would need to define text inside aes of ggplot.

... %>% ggplot(aes(x = date, y = revenue, text = paste('Date: ', as.Date(date), '<br>Revenue: ', revenue))) + geom_line() + ...

Collectives™ on Stack Overflow

Why doesn't plotly show the date properly on hover?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related