Just as I said, I must be making no sense at all.
The pitfalls aren't that much to think about since I would filter the results from the database first. The problem on the other hand is how to grab the information from the database. First it would have the sum up the total result, then filter to only show the current week/month. When that's done I would have one big result which doesn't make much of a chart. So from there I would have to add on single hunts from the week/month and in some manner make those two database requests live happily ever after. It's not meant to be easy.