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

0
7 comments
Official 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:

  1. You need to add 2 worklogs, like “1h30 : phone with client” and “30m : phone with client (but speaking about weather)”. It's quicker to add one worklog “2h-spent/1h30m-billed : phone with client”. Having a specific worklog of why 30m of phone is offered is level of detail not relevant for our clients
  2. You need to build and export 2 different reports. Then, you merge them together, and finally you can process all the worklogs lines in your external invoicing system

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.

0

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

0

Ok, so I could create an App inside the dashboard where I can :

  • search and select a project (to filter issues)
  • search and select an issue (in all projects or the one selected)
  • add a work item with fields message, user, work type, spent time, billed time, and all others custom fields of work items
  • when saved, it creates 2 worklogs with same values, except “spent time + billable=no” and “billed time + billable=yes”

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 : 

  • is it possible to edit such work items, with both spent time and billed time? At first glance, it seems not, but maybe a trick is possible?
  • can the embedded UI be implemented as a right-click menu over an issue (in the Agile board, for example)?
0

is it possible to edit such work items, with both spent time and billed time?

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.

can the embedded UI be implemented as a right-click menu over an issue (in the Agile board, for example)?

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.

0

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 ;-)  !

0

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.

0

Please sign in to leave a comment.