Views Calc

Posted by karens on May 17, 2006 at 7:57pm

I have a views_calc module in my sandbox that allows you to total a table of views fields across by row or down by columns. You can choose to SUM, COUNT, or AVERAGE the total. It includes a plugin theme that is more spreadsheet-like (right justifies numeric data, highlights and underlines the total columns, etc.)

I have it on a production site now at http://www.everbloom.us/home/results/views. On that page you see a summary view of cck nodes that contain fishing tournament results. When you select one, you see a view filtered by the argument for that date that totals the number of fish caught and the weight.

If anyone else is interested, you can find it in my sandbox at http://cvs.drupal.org/viewcvs/drupal/contributions/sandbox/karens/

If it seems useful, I can set it up as a project for further enhancement.

Comments

You are a champion. This

Posted by gordon on May 18, 2006 at 12:07am

You are a champion.

This gives me a real incentive to get the views intergration complete in E-Commerce.

Thanks.

--
Gordon Heydon

Nice

Posted by sime on May 18, 2006 at 2:06am

If it seems useful...

Nice understatement, KarenS. :-)

I've just dusted off my BusinessObjects/COGNOS hat. Is that drill-down/through behaviour easily configured?

The drill down comes from

Posted by karens on May 18, 2006 at 1:07pm

The drill down comes from creating a view that uses arguments for whatever value you want to filter on. Set up the argument to show a summary listing when you create the view. That will give you the effect you see on the page I pointed you to.

Views Calc doesn't get involved in any of that, that is all standard views stuff. Views Calc jumps in right after the views query has been executed and manipulates the results to calculate and format the totals, so you need to first create a view that produces the results you want to calculate.