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?
Code Snippet
pivot-table
conditions: Type = Task AND 'Development Status' = 'Finished'
aggregation: SUM('Work - Actual')
rows: 'Developer 1'
columns: 'Reporting - Iteration Complete'
empty-rows: true
empty-columns: true
totals: false
Pivot table questions
Comments
1 comment
Hey Chris
I'm not sure what the issue is with the timing out as this query does look simple enough but if you have a large number of cards or a heavily used Mingle server this may be the problem. If this persists then feel free to contact our support team who might be able to troubleshoot this after gathering more system information from you.
With regard to the second question, currently the columns and rows in the pivot table only support single properties and so I don't think you could create the table you want without manually creating property values for each of your pairs (pair = X+Y etc...). However, this report does sound like something that could be created using the macro development toolkit if you are so inclined.
Thanks
- Suzie
Please sign in to leave a comment.