Publications by HighlandR
Pass parameter to SQL Server DATEADD function using R
I wanted to try and create some parameters in my flexdashboard script, so I could extract data from our warehouse over a flexible date range. In SQL Server, I’d create a variable and reference it like this: DECLARE @ndays int SET @ndays = -7 SELECT cols, that, I , want FROM [server].[schema].[table1] t1 LEFT JOIN [server].[schema].[table2] t2 O...
3872 sym R (1660 sym/4 pcs) 2 img
Scheduling Rmarkdown files on Windows – your foolproof guide
You’ve written a great rmarkdown file, and now you want to run it at a set time every day. You’ve tried the Windows Task Scheduler, you’ve pointed it at your markdown file, and you’ve gone off to make some coffee safe in the knowledge that your outputs will be waiting for you when you get back to your desk… …Only they aren’t, becaus...
8271 sym R (564 sym/3 pcs) 12 img
cusumcharter available on CRAN
I submitted my cusumcharter package to CRAN late last Friday evening and was pleasantly surprised to receive an email early on Monday advising me it was on its way to CRAN. Big thanks to the CRAN maintainers who manage to work through the queues of packages so quickly. The package has several functions aimed at making it easier to create CUSUM ch...
5405 sym R (1358 sym/1 pcs) 4 img
Shooting Stars
This question popped up in my Twitter feed earlier, courtesy of @PipingHotData I did answer in a tweet, but I want to expand on that, so here goes.. Why would you follow someone on GitHub? I suppose the obvious one, at least for me, is that you like someone’s work – if I see someone has built 2 or 3 packages that I think are useful or intere...
9446 sym 12 img
I got my first package onto CRAN, and YOU CAN TOO
It’s almost 2 weeks since I had my first package successfully submitted to CRAN. The runcharter package is special to me for lots of reasons – it was a tough problem to crack, and it’s one I’ve worked on with a variety of tools over the years. If this package had existed back in 2012, (and if I’d known what R was back then), my working...
3895 sym