From mboxrd@z Thu Jan 1 00:00:00 1970 From: OSiUX Subject: Re: Generating burndown charts using org mode Date: Sat, 31 Dec 2011 08:40:24 -0300 Message-ID: <20111231114024.GA7146@merlot.gcoop.coop> References: <1325292994.28295.94.camel@lorenz> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="1yeeQ81UyVL57Vl7" Return-path: Received: from eggs.gnu.org ([140.186.70.92]:35052) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1RgxIi-00082A-Q5 for emacs-orgmode@gnu.org; Sat, 31 Dec 2011 06:40:37 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1RgxIg-000061-IU for emacs-orgmode@gnu.org; Sat, 31 Dec 2011 06:40:36 -0500 Received: from merlot.gcoop.coop ([67.208.113.123]:40861) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1RgxIg-0008WU-3p for emacs-orgmode@gnu.org; Sat, 31 Dec 2011 06:40:34 -0500 Received: from merlot.gcoop.coop (merlot [127.0.0.1]) (Authenticated sender: xuiso@osiux.com.ar) by merlot.gcoop.coop (Postfix) with ESMTPSA id C561F1491B9 for ; Sat, 31 Dec 2011 08:40:43 -0300 (ART) Content-Disposition: inline In-Reply-To: <1325292994.28295.94.camel@lorenz> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org --1yeeQ81UyVL57Vl7 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable El s=C3=A1b, 31 dic 2011, Marco Craveiro dec=C3=ADa: > Hi Org-Moders, > > I've been using Org-Mode quite a bit, but I'm afraid I'm not an advanced > user. I'm trying to generate burndown charts [1] which basically follow > coding progress over a bounded period of time (an iteration). > > I started by generating a file for each iteration: > > > * Tasks in iteration > - [[file:list_1.org]] > - [[file:list_2.org]] > > #+tblname: test_chart > | Day | Expected | Actual | > |-----+----------+--------| > | 0 | 4 | 4 | > | 1 | 3 | 4 | > | 2 | 2 | 1 | > | 3 | 1 | 0 | > | 4 | 0 | 0 | > Marco, try this: *** burndown #+srcname: burndown #+begin_src sh :session cd ~/org MONTH=3D$(date +%m) DAYS_DONE=3D$(egrep -A1 "\* DONE" gca.org | egrep -o "CLOSED: \[[0-9]{4= }-$MONTH-[0-9]{2}" | cut -c 10- | sort -u) echo "day expected actual" for DAY in $DAYS_DONE do NEXT_BY_DAY=3D$(egrep -A1 "\* NEXT" gca.org | egrep -o "SCHEDULED: <$= DAY" | wc -l) DONE_BY_DAY=3D$(egrep -A1 "\* DONE" gca.org | egrep -o "CLOSED: \[$DA= Y" | wc -l) echo $DAY $NEXT_BY_DAY $DONE_BY_DAY done #+end_src #+results: burndown | day | expected | actual | | 2011-12-01 | 5 | 1 | | 2011-12-05 | 3 | 1 | | 2011-12-12 | 4 | 2 | | 2011-12-13 | 2 | 1 | | 2011-12-14 | 2 | 2 | | 2011-12-15 | 2 | 2 | | 2011-12-16 | 2 | 1 | | 2011-12-19 | 1 | 2 | | 2011-12-20 | 0 | 4 | | 2011-12-21 | 0 | 6 | | 2011-12-22 | 0 | 1 | | 2011-12-26 | 0 | 2 | | 2011-12-27 | 0 | 3 | #+begin_src gnuplot :var data=3Dburndown :file burdown.png reset set xdata time set timefmt "%Y-%m-%d" set format x "%d" set title "burndown" set xlabel "days" set ylabel "taks" set xtics nomirror set ytics nomirror plot data using 1:2 with lines lw 2 lt 3 title col(2), \ data using 1:3 with lines lw 2 lt 1 title col(3) #+end_src #+results: file:burdown.png -- :: Osiris Alejandro Gomez (OSiUX) osiux@osiux.com.ar AA70 93FD B6EF EB42 6920 7530 A799 B226 74C8 A3FE http://osiux.com http://wiki.buenosaireslibre.org --1yeeQ81UyVL57Vl7 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iQIcBAEBAgAGBQJO/vSoAAoJEKeZsiZ0yKP+ZyoQAND7KY8XXTbIRVa7Y8DmyPub xT2AzKNQacbsiQCbsScj3RGoVnsjRGOj43FS8EkhgJ1yNJGn2nuoONbvYWjqjwJt pnwrT+jp/0GB5QNTgZeknNSWmJnKG/bGFn11kALZQrd9v6breaeuIegBYt6HT/X2 y6AcTn7IIpM3OgGT8RZH45NJwEdEyCF0NpRFAAIdV720sa/1MdsKJvUoUWG1YOAy qzbkrfboKwcsjfUvFKdmfQNCSmvTDsabqnRBc4o2a8qjB1qmUiOp+9H/EZ1QvOI/ pd8PiruSUzTy+JH725RS6MFS30JhfKb0z7Si/fneTwPrluXRyLp57DlbNCu6Xvjk A3bxmyFF9bhq0gJwWqOlSf5fzYcLbOakMhR/7pqmrQ6be44SpW+TWBS7/MEpHigm MP1ooZ5WC2r6HFkeonRrggb6QdyuyZ8RFezxSduhua+JM1luBaHNG+hHDW4gIHks Clzahhne9SkjxOFtO830enwRnP87YslICUcmBpIlOq82xqE4+HJxv72/+yfD6YRM mvc+rgV3LL7xH0VomtyRsaSsUhwHZ9ktOVrBv1k0cIbeyOUWTAJe3cEys9SA3NoK A+hroxDXTfAKNsefvThKt4pXPeHP2FP7TUbVET1jKUyRprYq1Oq+UcvvybcmvxHd EtfSEpu0NUvqbs0XlufP =XlZ3 -----END PGP SIGNATURE----- --1yeeQ81UyVL57Vl7--