Views Calc Table

This module adds simple calculations to a views table. Requires the Views module.

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).

You can also create custom dynamic fields that can be used in any view using SQL snippets like CONCAT('field_first_name', ' ', 'field_last_name') or DATE_FORMAT(node.created, '%m/%%d/%Y'). The custom fields are set up in admin/settings/views_calc.

Known Issues

  • Some things work with relationships, depending on the complexity of the view.
  • Custom fields can't do anything intelligent with multiple value CCK fields. For now stick to single value fields in custom fields.

Credits

Views Calc is maintained by KarenS.
A partial resource-optimized rewrite, major cleanup (6.x-2.x), a Port for Views 6.x-3.x and a Port for Drupal 7 was provided by Miro Dietiker of MD Systems.

Project Information

Downloads