Timesheet report with spent time and billed time?
Hello,
I have four questions about timesheet report:
1. In any issue, the “Add Spent Time” popup
- we have the standard “Spent time” field
- Is it possible to add, next to or below this field, a new “Billed time” field
- the goal is to have the opportunity to say “today I have worked 2 hours, but only 1 hour is billable”
2. In a Timesheet Report
- Is it possible to show, grouped by user, all the worklogs, with the “spent time” column and a new “billed time” column?
- the goal is to quickly see that “I have worked 78 hours on this project, but only 60 hours will be billed”
3. In a Timesheet Report XSLX/CSV export
- is it possible to have all worklogs for all users, with the “spent time” column and a new “billed time” column?
- the goal is to be able to use spent and billed times in some import scripts (like an external invoicing system)
4. Future developments
- if all of this is not possible, is this planned as a future development somehow, or is possible to create something through the Youtrack RestAPI?
Thanks
Please sign in to leave a comment.
Hi Fabien! In project settings > Time Tracking, you can add your own custom work item attributes. For example, “Billable”:
In the Time report, you have an option to select the values in this attribute. This way, only issues with the values you need will be included in the report data:
For more information on this feature, see: Manage Work Item Attributes.
Thanks for your answer!
Ok, I see the point. It would have been so cool adding a work item attribute with a type “period” (like Spent time), but it seems that's not possible (for now?)
I see 2 drawbacks in your suggestion:
This technique is indeed functional. Thanks for bringing it to my attention.
But because of the inherent lazyness of human beign, I doubt it will be efficient enough on the long term. Probably the Spent time will be equal to Billed time in the end after a couple of weeks/months, losing this difference between worked and billed hours.
Is it possible to build a plugin for that? Does the API have the capability to add this kind of fields in these places?
Thanks.
Work items in YouTrack don't have period fields, only attributes (that I mentioned earlier) that are more similar to enum fields. There is also no API for what you describe in work items; the available attributes are listed here: IssueWorkItem.
As for building the plugin: what I think may work is for a custom app in YouTrack to provide an embedded UI that matches your idea of how your colleagues could add billable and non-billable hours with less effort. Then the app would save everyone some clicks by parsing this input and transforming it into split work items, and these separate work items would have the corresponding value in the “Billable” custom attribute (“Yes” or “No”).
Ok, so I could create an App inside the dashboard where I can :
This is interesting, but I never created apps in youtrack before. I do not realize if this is a hudge work or not.
And this brings some questions :
In the suggested approach, the outcome would be separate work items for billable and non-billable spent time. Each of the work items can then be edited separately.
I'm afraid not. The app UI can be embedded under the issue description, in the issue fields section, or as a dashboard widget (these three options should be the best candidates for this specific solution). For more information on page locations where it can be embedded, see: Extension Points for Widgets.
Ok, thanks for your advices.
I think I have everything to start something.
I'll expermient a bit with a small project first. If it's conclusive, we will migrate to Youtrack ;-) !
Sounds great! Feel free to reach out again if you get any other questions. You can also submit your questions to us in private tickets using this link: https://jb.gg/ytsup.