Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I've got a timesheet node that contains the following:
Name | Start Date| End Date | Duration | Activity Type
The duration is a computed field based upon the start and end date.
A standard views table can provide the following display:
| name | duration | activity |
| ben | 2 | admin |
| ben | 3 | training |
| joe | 1 | admin |
| joe | 4 | admin |
| mike | 6 | training |
What I would like to do, is create a summary of activities and time:
| name | admin | training | grand total |
| ben | 2 | 3 | 5 |
| joe | 5 | 5 | |
| mike | 6 | 6 |
I've tried every combination of enumeration, tally, and sum, but the best I can get is a count for the activity:
| name | activity | total |
| ben | admin(1) training(1) | 5 |
| joe | admin(2) | 5 |
| mike | training(6) | 6 |
Can this module do what I want? It seems like it should, but I just can't quite figure it out.
Comments
Comment #1
bhosmer commentedComment #2
rdeboerHi Ben,
Sorry for
1) responding late
2) saying no to your question - I don't think you'll be able to what you want; I have been thinking of using Views PHP and expressions, but it won't be straightforward.
Rik
Comment #3
bhosmer commentedNo problem. In case someone else finds this though, I was able to accomplish it using Views Field View along with the VAP module.
Comment #4
rdeboerThanks for the tip Ben!
I've referred to your comment from the project page.
Rik