calculate bugs per day and plot it

[debbugs-presentations.git] / debbugs.Rnw

diff --git a/debbugs.Rnw b/debbugs.Rnw
index 66fd5fbd345c39433d3d6729349b692968a690c7..e53a79c380c7b64630c1ab752b3f649a4e047851 100644 (file)
--- a/debbugs.Rnw
+++ b/debbugs.Rnw
@@ -43,8 +43,8 @@
     \end{tikzpicture}}
 \author{Don Armstrong}
 \title{Debbugs}
-\subtitle{Database Ho!}
-%\date{August 11th, 2008}
+\subtitle{22 Years of Bugs}
+\date{August 10th, 2017}
 \titlegraphic{\includegraphics[height=0.2\textheight,keepaspectratio]{figures/openlogo-crop.pdf}}
 \subject{BTS}
 
@@ -99,7 +99,10 @@ scientific_10 <- function(x) {
 %\setbeamercolor{frametitle}[bg=-red!90!green!10,fg=black]
 
 \frame[plain]{\titlepage
-  Source available at \url{http://git.donarmstrong.com/debbugs-presentations.git}
+  Code and slides are here: 
+  \qrcode[padding]{https://dla2.us/p/debbugs2017}
+  \url{https://dla2.us/p/debbugs2017}
+
 }
 
 % \begin{frame}{Debbugs}
@@ -113,8 +116,7 @@ scientific_10 <- function(x) {
   \begin{columns}
     \column{0.5\textwidth}
     \begin{itemize}
-    \item Bug Statitics
-    \item Introduction to Debbugs
+    \item Bug Statistics
     \item New features
     \item Planned features
     \item Places you can help
@@ -145,10 +147,16 @@ scientific_10 <- function(x) {
 bug.growth <- fread("data/sorted_bug_growth_for_r_every_500.txt")
 colnames(bug.growth) <- c("time","bugs")
 bug.growth <- bug.growth[pmax(bugs) <= as.numeric(bugs),]
+bug.growth <- bug.growth[order(time),]
+bug.growth <-
+    bug.growth[c(0,diff(bugs))>=0,]
 bug.growth[,date:=
                 as.POSIXct(ISOdatetime(1970,1,1,0,0,0)+
                            as.numeric(bug.growth$time))]
-print(ggplot(bug.growth[date > as.POSIXct(ISOdatetime(2005,1,1,0,0,0)),],
+bug.growth[,`bugs per day`:=c(0,diff(bugs)/
+                                as.double(diff(date),"days"))
+           ]
+print(ggplot(bug.growth,#[date > as.POSIXct(ISOdatetime(2005,1,1,0,0,0)),],
              aes(x=date,y=bugs))+
       xlab("Time")+ylab("Bugs filed in Debian")+
       scale_y_continuous(labels = scientific_10)+
@@ -157,7 +165,20 @@ print(ggplot(bug.growth[date > as.POSIXct(ISOdatetime(2005,1,1,0,0,0)),],
 \end{center}
 \end{frame}
 
-\begin{frame}
+\begin{frame}{Bug Growth Rate}
+<<bug_growth_rate,echo=FALSE>>=
+print(ggplot(bug.growth[date > as.POSIXct(ISOdatetime(2014,1,1,0,0,0)),],
+             aes(x=date,y=`bugs per day`))+
+      xlab("Time")+ylab("Bugs filed per day")
+      + scale_y_log10(breaks=c(60,100,200,400,800))
+      + geom_line()+stat_smooth(method="lm")
+      + geom_label(data=data.table(date=as.POSIXct(ISOdatetime(2015,04,25,0,0,0)),"bugs per day"=400),label="Jessie",color="red")
+      + geom_label(data=data.table(date=as.POSIXct(ISOdatetime(2017,06,17,0,0,0)),"bugs per day"=400),label="Stretch",color="purple")
+      )
+@ 
+\end{frame}
+
+\begin{frame}{My entries into Cristian's game}
   \begin{columns}
     \column{0.5\textwidth}
   \begin{center}