I'm working up my first pivot table so I can get a feeling for where work is getting done. My first experiment is attached in the code snippet table, looking at completed tasks, summing up actual work by developer and iteration.
I've actually got two problems. First is that the results don't show up: the page rendering fails with a timeout after 30 seconds. I'm a bit surprised by this, as it doesn't seem like that heavyweight a query, is there some tuning that I have to do?
Next, I want to do something a bit more advanced than just defining rows on the basis of a single property. One thing I could imagine doing is wanting the rows to be defined by the unique set of Developer 1 and Developer 2, and aggregation be based on when user = Chris as either Dev1 or Dev2. In this case, actual work would get double counted (1 for each dev if worked on as a pair), but that's what I'd want. Is there some kind of OR functionality in row/column that lets one do things like that?
I also want to know whether I can do a compound grouping for rows, so Dev 1 + Dev 2. So Chris+X did 15 pts of work during the iteration, X+Y did 10, etc. Ideally I'd want X+Y and Y+X to aggregate together, as it's really a unordered pair.
I'd try and figure out some of these answers myself, but the fact that the basic pivot table times out is limiting my experimentation a bit. Can anyone tell me if this sort of thing is possible?
conditions: Type = Task AND 'Development Status' = 'Finished'
aggregation: SUM('Work - Actual')
rows: 'Developer 1'
columns: 'Reporting - Iteration Complete'