How do I get information or a report on the sum of hours applied to each work item ID?
Follow

Leah Copeland

January 25, 2018 16:08

Updated

Question

I am trying to run a report of the SUM of Hours applied to each work item ID. What do you recommend to be able to run an "Hours Worked" report from the data collected by the extension? In other words, how to I get a report that shows, per TFS ID for a project, how many total hours have been applied to it?

Timetracker also has a reporting API that provides a dedicated URL that allows you to access and extract pure, updated data from Timetracker into the system of your choice as OData feed (e.g. Excel, PowerBI, Tableau, Qlikview, SQL, or any third-party system that “talks” the protocol that our API is offering). For more information about using the API and OData feed, see "Settings": API for 7pace Timetracker for TFS or "Settings": API for 7pace Timetracker for VSTS in our user documentation.