I'm beginning with a working D7 install and I am now working on this event content type problem. I have:
+ Content type called "event" (title, date, body, category);
+ Views page display list:
|-- Each event in a given category has its own page;
|-- Naturally, each event has its data fields in the list;
|-- I want to add to my Views page is the programmatic aggregate of the "date field" data where the result of the calculation = "current date" + "next five scheduled event dates of any category" prints a list of the next five events of any category.

Thus the page has default limit to 10 items of one category. Added to each item in the list are the titles of the next five events of any category.

Can I accomplish this with Views 3 Module built-in functionality? Or do I need another module? And IRC comment suggested maybe views_php [1] module?

-----
[1]: http://drupal.org/project/views_php

Comments

brycesenz’s picture

I agree with the IRC comment that views php is the module to turn to - for display random database queries in views, it's a lifesaver.

xtiansimon’s picture

Would you please elaborate on your response? How does the Views php module implement aggregate data in views?

brycesenz’s picture

Views PHP allows you to write custom php queries within Views. So you can write whatever SQL code and pull together whatever aggregate data you need within views without any issue.