3

There are a few views that gather and analyze data from several nodes to form a budget based on their workflow. These views have a "total" area (defined as a custom content field within the view), which calculates the the total amount of money allocated by each node. enter image description here Each node is also associated with a team object, and what I want to accomplish is to get the "total" field from each view to act as a column in another view, so we can see how much money was allocated/spent with each team.

Essentially, what I'm trying to do looks more or less like this:

Team Number | View 1 Total | View 2 Total | View 3 Total | Total of the Totals
1           |          $33 |         $-10 |         $-20 |                  $3
2           |          $50 |         $-15 |         $-10 |                 $25

I've looked into trying views-field-view, but I haven't been able to find an option that allows me to select that specific row, which is created with a summarized table as the format. This is the same across all three views. How would I go about achieving this, with either views-field-view or another module? Or should I just go ahead and do this with a panel using custom PHP code?

3
2

You can combine the Views Field View module with the Views Aggregator Plus or with the Views Calc module.

Views Calc:

Adds simple calculations to a views table. You can SUM, AVERAGE, COUNT, MIN, MAX, or AVG selected columns. A plug in theme makes the view look more spreadsheet-like (right justifies numeric fields, shades calculated columns and rows, and underlines calculated rows).

Views Aggregator Plus:

In addition to what Views and Views Calc do, this module:

  • enumerates group members
  • produces tallies, i.e. textual histograms
  • aggregates on Views PHP code-snippet evalutations
  • can filter out result rows on regexp patterns
  • gives you sorting on Views' Math expressions
  • can process Webform submissions
  • lets you add your own custom aggregation functions

... and it puts summary statistics at the bottom of your aggregated table as well!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.