I need to create a custom visualisation using rstudio packages,
I cobbled this example from online sources but it still doesn't work perfectly.
The table needs to calculate X and Y coordinates in their axis, and also draw a line by the dates these points were created, I added examples to the image of the table created through ProChain, note that the line goes backwards, something the regular PBI scatter is unable to do.
Here's the code I have so far, it's almost true, but I can not find any example of a scatter lined chart and I would love to hear advice, I'm not an expert on R \ PY, it's combinations of things I found online.
library(ggplot2) library(dplyr) dataset <- dataset[order(dataset$StatusDate),] dataset %>% ggplot(aes(x=PercentChainDoneTrimmed, y=PercentBufferConsumedTrimmed, colour=RescheduleDate)) + geom_point() + geom_segment(aes( xend=c(tail(PercentChainDoneTrimmed, n=-1), NA), yend=c(tail(PercentBufferConsumedTrimmed, n=-1), NA) ) )