By jtopjian on

Hello,

I have a content type in which a user will enter a Date as well as a Distance Traveled.

Showing individual entries is easy enough, but I would like to create a few views which summarize that data and I'm not sure how to proceed.

For example, I would like to create a Block View which displays each month and the total distance traveled for each:

Month Summary
------------------
January: 600mi
February: 300mi

I'd also like to do Week and Year, but I guess implementing the same solution as Month Summary would be the same for Week and Year.

Any help or pointers would be greatly appreciated.
Thanks,
Joe

⋅ Categories: Drupal 6.x

Comments

WorldFallz’s picture

WorldFallz commented

You might be able to do this with the http://drupal.org/project/views_calc or http://drupal.org/project/views_customfield modules.

jtopjian’s picture

jtopjian commented

Thank you for the suggestions! Unfortunately they didn't work for me and I just ended up making a few blocks with embedded PHP/SQL. But I know these modules will come in use later on.