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

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. 

0 vote

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

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Sunday in Agility

You asked for it, so we delivered: images on issues have arrived

A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...

696 views 3 11
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