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
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
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<
3 matches
Mail list logo