Split up time spent evenly over number of checked options

Hello,

I've added a checkbox custom field "billable" to assign the time spent to a certain option (customer). Sometimes an assignee will check more than 1 option when Time Spent needs to be evenly distributed over two or more customers.

When we export the data (using Time keeping tool) at the end of the month we can only get the total amount of Time Spent for each issue, and all checked options in a single cell (separated with commas).

Is there a way to split up the time spent over the amount of checked options in the custom field?

In a ideal world every checked option in the "billable" field would have its own line in the spreadsheet export, containing an even amount of time spent for each line. But I'll settle for any solution that allows me to split up the total amount of time :)

Thank you for your thoughts,

Tom

3 answers

This widget could not be displayed.

Hi Tom, 

I think that the generic JIRA Timesheet report is not too adjustable, so there is not much room to change scope of the data exported. 

However if you have actually added custom field, why not use some JQL query in order to get the list or table with the time spent values and then export this JQL report to xls? This seem to me as a good option, the other more sophisticated is to use Tempo for much more detail tracking and reporting against time. 

This widget could not be displayed.

Create a calculated field for the Better Excel Plugin, that divides the timeSpent field's value among the customers. It does not look very difficult if you really need to just div it evenly.

Then create a custom template that utilizes this field.

For inspiration, see these examples.

jira-cross-project-worklog-report-components-pivot-chart

This widget could not be displayed.

Thanks for the feedback!

True,  the generic JIRA Timesheet report doesn't do much good :)
We use the "Time Reports and Gadgets for JIRA Cloud" add-on instead.

There doesn't seem to be a setting in the add-on that lets me split up time per chosen option in a custom field. So I just wondered if maybe we could use a different type of custom field to adjust the data in the excel export. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Friday in Jira

New 5k User Limit and Other Cloud Updates

Hi all! Lauren here from the Enterprise Cloud marketing team.  I have some exciting Cloud updates from #AtlassianSummit that I wanted to share. We want everyone in your organization to be ab...

94 views 0 3
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you