From: | Eberhard Lisse <nospam(at)lisse(dot)NA> |
---|---|
To: | pgsql-general(at)postgresql(dot)org pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Potentially annoying question about date ranges (part 2) |
Date: | 2006-10-03 05:04:35 |
Message-ID: | al79v3-5ev.ln1@ac.lisse.NA |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
I have a similar question,
I receive payments, but not every day (or even every week),
and I would like see how much I receive per week and/or per
month. I also need to compare different years.
I also would like to see what the (accumulated) sum of the
payments is at the end of a given week, month.
And then of course I would like to show this to someone, ie
make a graph. X-Axis 12 months (or 52 weeks). Left X-Axis the amounts
for the bars which should be in different colors (per month/bar), right
Y-Axis the amounts for the totals as a line (so that the bars don't
become too flat).
If such a combined graph is not possible/feasible, I could live with
one plot each per year.
I got the usual tools on the Mac, including R, gnuplot and fink.
any help would be appreciated.
el
on 9/30/06 8:34 PM Jan Danielsson said the following:
> I'm going to assume that this question has been asked a gazillion
> times, and is in every SQL book known to man and aliens. And I also
> assume it is in the FAQ. But I'm going to ask anyway.
>
> I have a database in which I store my purchases -- mainly for
> entertainment (you have no idea how dull my life is).
>
> In an effort to get some variation in my life, I thought I'd find
> out how much of my valuable money I waste each day - on average.
--
If you want to email me, replace nospam with el
From | Date | Subject | |
---|---|---|---|
Next Message | pd | 2006-10-03 05:56:57 | Run programs within the bin folder |
Previous Message | Morgan Kita | 2006-10-03 00:21:40 | Foreign keys, arrays, and uniqueness |
From | Date | Subject | |
---|---|---|---|
Next Message | Srinivas Iyyer | 2006-10-03 15:37:27 | getting counts . .please help |
Previous Message | Brandon Aiken | 2006-10-02 15:36:39 | Re: Activate a function on the PostgreSQL server |