It's all about the answers!

Ask a question

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


Vikas Kumar (132) | asked Jun 13 '16, 11:25 a.m.
edited Jun 13 '16, 11:39 a.m.
 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

Accepted answer


permanent link
Ralph Schoon (63.1k33646) | answered Jun 15 '16, 2:44 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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

Comments
Vikas Kumar commented Jun 15 '16, 9:29 a.m.

 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.


Ralph Schoon commented Jun 16 '16, 2:25 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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 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.