Add node week count?

Question

Drupal just stores the day count and the total count. Is there a way to give a week count to the node?

ps: i want to show a node title list.the sort creteria is decending the most viewsd in a week. by defaule Drupal just stores the day count and the total count. there is no week count.

could i use this: i add a node created time in a sql query which where clause is less than time()-24*7 like this where node time created < time()-24*7)then i use the total node count. then descending the result. the node title show will be the same as the week count. am i right? if right, how to put the sql query to views sort creteria .

Answer 1

You can use this not so well maintained module Statistics Granularity or learn how to do it yourself with this blog post: Advanced statistics for Drupal: most viewed nodes in a week, month, ...

Answer 2

In case you are using views3, you can use the GROUP BY functions and do it via SQL. Alternatively there is a seperate module for views2.