Hi,
I've got a database table containing
JobNumber - JobRaisedDate - JobCompleted Date
What I'd like to do is have a graph showing:
* Total Jobs Raised
* Total Jobs Completed
...for every week.
Sounds easy but here's the thing: when I group on raised date I get all the jobs that were raised in the week + any jobs that we're raised and completed in that week. I'm missing jobs that were raised prior to that week.
I feel like I'm missing something simple with this. Any suggestions?
Cheers,
Pete
I've got a database table containing
JobNumber - JobRaisedDate - JobCompleted Date
What I'd like to do is have a graph showing:
* Total Jobs Raised
* Total Jobs Completed
...for every week.
Sounds easy but here's the thing: when I group on raised date I get all the jobs that were raised in the week + any jobs that we're raised and completed in that week. I'm missing jobs that were raised prior to that week.
I feel like I'm missing something simple with this. Any suggestions?
Cheers,
Pete