[R] Getting multiple tables when using table(dataframe) to tabulate data

2008-02-28 Thread obradoa
I am having hard time tabulating data in a dataframe, and getting a single "table" for an answer. I am trying to tabulate all "counts" for given "status" on a given date. I have a data frame such as: delta_ts status count 1 2008-02-27 CLOSED 3 2 2008-02-27 NEW

Re: [R] Advice on plotting a factor and displaying missing levels

2008-01-19 Thread obradoa
Great, this would work. Is it also possible to plot zero values for each missing day, so when I do the line graph it properly drops to 0 if there was no data for that day? Currently the line graph connects dots that represent days with data present, but the line graph never drops to 0. I'd appreci

[R] Advice on plotting a factor and displaying missing levels

2008-01-19 Thread obradoa
I am trying to plot how many records are inserted into a database on a certain date, but also represent days where no records are inserted. I can get a list of dates for inserted records using RMySQL result <- dbSendQuery(con, "select date_format(creation_ts, "%m/%d/%y") from mytable;") inserts<