# Sum of points for last seven days

**URL:** <https://www.ruby-forum.com/t/sum-of-points-for-last-seven-days/125568>\
**Category:** Rails\
**Created:** [January 10, 2008, 8:45am UTC](https://www.ruby-forum.com/t/sum-of-points-for-last-seven-days/125568 "2008-01-10T08:45:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chubbs](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/47e85d/32.png) [@Chubbs](https://www.ruby-forum.com/u/Chubbs)\
**Post date:** [January 10, 2008, 8:45am UTC](https://www.ruby-forum.com/t/sum-of-points-for-last-seven-days/125568/1 "2008-01-10T08:45:57Z")

</div>

Hey guys,

im very very stuck trying to figure out how to go about implementing a  
sum method to sum up the points a user gained for each day of the  
week.

schema:  
create\_table “user\_point\_logs”, :force =\> true do |t|  
t.column “user\_id”, :integer  
t.column “points”, :integer  
t.column “created\_at”, :datetime  
end

I want to be about to simply calculate the total points the user  
gained for the last seven days.

I got this so far.  
controller:  
@statistics = @current\_user.user\_point\_logs.find(:all,  
:conditions =\> [‘created\_at \> ?’, 7.days.ago])

view:  
@statistics.sum(&:points)

can any provided me some snippets to help me out?

regards,

Chubbs

---

<div class="post-metadata">

**Author:** ![Chubbs](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/47e85d/32.png) [@Chubbs](https://www.ruby-forum.com/u/Chubbs)\
**Post date:** [January 10, 2008, 9:08am UTC](https://www.ruby-forum.com/t/sum-of-points-for-last-seven-days/125568/2 "2008-01-10T09:08:48Z")

</div>

i made some improve if anyone can improve on it more to help me,

i got this so far

@stats = @current\_user.user\_point\_logs.sum(:points, :group =\>  
‘created\_at’)

but i want to fine tune it to work only for the last 7 days

---

<div class="post-metadata">

**Author:** ![Chubbs](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/47e85d/32.png) [@Chubbs](https://www.ruby-forum.com/u/Chubbs)\
**Post date:** [January 10, 2008, 9:11am UTC](https://www.ruby-forum.com/t/sum-of-points-for-last-seven-days/125568/3 "2008-01-10T09:11:43Z")

</div>

no worries !!

thanks all good, worked it out

for your interests…

```
@stats = @current_user.user_point_logs.sum(:points,
  :group => 'date(created_at)',
  :conditions => ['created_at > ?', 7.days.ago])
```