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
- The complex queries created are not relationship-safe yet, so you can't do accurate calculations on fields coming from relationships.
- Custom fields can't do anything intelligent with multiple value CCK fields. For now stick to single value fields in custom fields.
- After Drupal 7 Core changed a lot with fields in the last days before final release, the previously working Views Calc needs complete overhaul again. We consider it broken now and there's a lot work needed to make it work again. Check the issue for more information. Queries without Drupal core fields should still work.
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 has recently been submitted by Miro Dietiker of MD Systems.
Project Information
- Maintenance status: Actively maintained
- Development status: Under active development
- Module categories: Content Display, Views
- Reported installs: 5546 sites currently report using this module. View usage statistics.
- Last modified: November 29, 2011
