It's all about the answers!

Ask a question

Summing the results of a queery


Paul Bishop (1154) | asked Jan 19 '09, 11:56 a.m.
Hi there

does anyone know how this could be done,

for example generating a list of hours worked on various work items by a person and then adding together the hours returned

thanks

Paul

4 answers



permanent link
Patrick Streule (4.9k21) | answered Jan 20 '09, 3:18 a.m.
JAZZ DEVELOPER
does anyone know how this could be done,

for example generating a list of hours worked on various work items by
a person and then adding together the hours returned

I believe the Iteration Plans already provide this data for each team
member.

Otherwise, you could export a query as a CSV spreadsheet and sum up the
values in Excel.

--
Regards,
Patrick
Jazz Work Item Team

permanent link
Paul Bishop (1154) | answered Jan 20 '09, 6:32 a.m.
Ok thanks I'll have a look at that

---------------

does anyone know how this could be done,

for example generating a list of hours worked on various work items by
a person and then adding together the hours returned

I believe the Iteration Plans already provide this data for each team
member.

Otherwise, you could export a query as a CSV spreadsheet and sum up the
values in Excel.

--
Regards,
Patrick
Jazz Work Item Team

permanent link
Astrid Kreissig (3164) | answered Mar 19 '09, 4:06 a.m.
I would like to export queries about work items and th etime spent or estimated to a spreadsheet. But the export fucntion generates out put like '2 day', 4'hours',.. That can not be summed up, so I have to manually chaneg this to a number of hours.
Is there a way arond it?

permanent link
Astrid Kreissig (3164) | answered Mar 19 '09, 4:55 a.m.
I would like to export queries about work items and th etime spent or estimated to a spreadsheet. But the export fucntion generates out put like '2 day', 4'hours',.. That can not be summed up, so I have to manually chaneg this to a number of hours.
Is there a way arond it?



sorry, i asked taht alread y and foudn teh answer :?

Your answer


Register or to post your answer.