Data Smoothing with Splines
We love this visual. How should the script read if my dates are formatted as mm/dd/yyyy?
Thanks
Hi, sorry for the delay in reply.
The X column is of type "numeric". You can convert "date" type to "numeric" in Power Query. Next you need to take care of X-axis ticks labels, to be formatted as you want.
I did something similar in
https://community.powerbi.com/t5/R-Script-Showcase/ARIMA-forecasting/m-p/124237Please have a look at the R code. If you still have trouble with it, you are welcome to send me the PBIX
Been looking at this visualization lately as I need to plot some datapoints and need to add regression lines. I'm plotting revenue/sales per day, and using the date as the category/legend. However, I need one line for each of the days, instead of one for all the data points.
How much work am I looking at doing smoething like this in R?Hi,
This is quite simple to achieve if you have basic expertise in R.
I'd also recommend you to look at R Custom Visual "Spline" it has regression lines
You can use it as a starting point.
