Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Is there any way we can get cumulative sum of Time Spent and Time Tracking values?

 We are implementing Time Tracking tab to our work items. But when we are trying to add time using Time Tracking tab, it is erasing the whose value which is already present in the Time Spent Field. Is there any way we can get cumulative value of both Time Spent and Time Tracking Values.

Thanks

0 votes


Accepted answer

Permanent link
If Time Tracking is enabled you usually enable (Process configuration>Project configuration>Configuration Data>Planning>Time Tracking>Synchronize Time Spent with Time tracking, so that you get consistent data in time tracking and time spent. Time Spent is (documentation) set to read only as well, so that you can not create inconsistent data.

You can uncheck that box, but then both data is independent and you basically end up with totally unrelated data. I don't know how you would/could consistently report in this scenario and it does not at all make sense to me.
Ralph Schoon selected this answer as the correct answer

0 votes

Comments

 The thing is ,Time Spent tab is already implemented before Time Tracking. Users manually entered values in Time Spent. Now I implemented Time Tracking and did what all you mentioned above like Synchronize Time Spent with Time tracking and read only. Its working properly for new work items but work items which are created before implementing Time Tracking contains some existing data in Time Spent field. But when we are trying to add time using Time Tracking tab, it is erasing the whose value which is already present in the Time Spent Field and showing up only the values which are entered using Time Tracking. So now the data which exists in Time Spent for old work items, how can we add with time tracking so that there wont be any inconsistent data.

You can't have it all. You could add a custom attribute and move the old time spent data into that and you could calculate the real value from the sum of both. You will have to consolidate the data, otherwise this is not going to work for you.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,126

Question asked: Jun 13 '16, 11:25 a.m.

Question was seen: 2,122 times

Last updated: Jun 16 '16, 2:25 a.m.

Confirmation Cancel Confirm