Re: Generating burndown charts using org mode

[OSiUX <xuiso@osiux.com.ar>]

[-- Attachment #1: Type: text/plain, Size: 2519 bytes --]

El sáb, 31 dic 2011, Marco Craveiro decía:

> 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:
>
> <snippet_of_org_file>
> * 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 |
> </snippet_of_org_file>

Marco, try this:

<snippet_of_org_file>
*** burndown

    #+srcname: burndown
    #+begin_src sh :session
    cd ~/org
    MONTH=$(date +%m)
    DAYS_DONE=$(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=$(egrep -A1 "\* NEXT" gca.org | egrep -o "SCHEDULED: <$DAY" | wc -l)
      DONE_BY_DAY=$(egrep -A1 "\* DONE" gca.org | egrep -o "CLOSED: \[$DAY" | 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=burndown :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
</snippet_of_org_file>

--

::

  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

[-- Attachment #2: Digital signature --]
[-- Type: application/pgp-signature, Size: 836 bytes --]