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

bhosmer’s picture

bhosmer commented
Issue summary: View changes
rdeboer’s picture

rdeboer
Location Melbourne
commented
Status: Active » Closed (won't fix)

Hi 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

bhosmer’s picture

bhosmer commented

No problem. In case someone else finds this though, I was able to accomplish it using Views Field View along with the VAP module.

rdeboer’s picture

rdeboer
Location Melbourne
commented

Thanks for the tip Ben!
I've referred to your comment from the project page.
Rik