emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

From: "Loris Bennett" <loris.bennett@fu-berlin.de>
To: emacs-orgmode@gnu.org
Subject: Referring to results rather than code block
Date: Mon, 19 May 2014 16:11:29 +0200	[thread overview]
Message-ID: <87iop1eu3y.fsf@hornfels.zedat.fu-berlin.de> (raw)

Hi,

I have a code block like this

#+NAME: users_per_month
#+HEADER: :results append
#+BEGIN_SRC sh :dir /root@sadmin:
sacct=/cm/shared/apps/slurm/current/bin/sacct
for y in {2014..2014}; do
    for m in {03..04}; do
        month=$y-$m
        first=$y-$m-01
        last=`date -d "$first + 1 month - 1 day" +"%Y-%m-%d"`
        n=`$sacct -S $first -E $last  -o user -X -n | sort | uniq | wc -l`
        echo $month $n
    done
done
#+END_SRC

which produces something like this

#+RESULTS: users_per_month
| 2012-01 |     1 |
| 2012-02 |    10 |
| 2012-03 |   100 |
| 2012-04 |  1000 |

I'm using append because the generation of a datapoint takes a while.

I'd like to plot the data with something like:

#+NAME: plot_users_per_month
#+HEADER: var data=users_per_month
#+HEADER: :results output graphics
#+HEADER: :file ./users_per_month.pdf :exports both
#+HEADER: :session *r*
#+BEGIN_SRC R
library(ggplot2)

bar_colour  <- "#69B4D8" # steely blue

month <- data$V1
users <- data$V2
df <- data.frame(month,users)
p <- ggplot(df,aes(x=month,y=users)) +
  geom_bar(stat="identity",alpha=0.5,fill=bar_colour) +
      xlab("date") +
        ylab("users")
p
#+END_SRC

However, this is just generating a plot of the data generated by the
source block and not of the total results table.

Can I give the results block a different name to the source block, so
that I can refer to it directly, or should I be doing something
completely different?

Cheers,

Loris
 
-- 
This signature is currently under construction.

next             reply	other threads:[~2014-05-19 14:12 UTC|newest]

Thread overview: 3+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2014-05-19 14:11 Loris Bennett [this message]
2014-05-19 15:25 ` Referring to results rather than code block Nick Dokos
2014-05-20  8:55   ` Loris Bennett

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=87iop1eu3y.fsf@hornfels.zedat.fu-berlin.de \
    --to=loris.bennett@fu-berlin.de \
    --cc=emacs-orgmode@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).