Getting % of time spent

[paul carlson]

Here is what I'm trying to do.

We have said the devs are going to spend 50% of time on bug triage and 50% on new feature development.  Now we have created tasks where the devs will enter by sprint the amount of time in bug triage, now I'm trying to figure out by engineer how much time in % they are spending, wanted to do a simple calculation were 80/time spent would give me that % but I can't seem to get started.

Anybody else do this?

Thanks

Paul

[Mehmet A _Bloompeak_]

Hi @paul carlson ,

As Lisa mentioned there is not too much built-in reports. As an alternative, you can try Reports - Charts and Graphs for Jira app developed by our team.

Here is a sample report that shows sum of time spent by issue type in each sprint.

If you need a different type of report, feel free to schedule a free Q&A call with us.

You can create various charts using the app.

• You can set X axis to be any parameter like Created(month), Assignee, Sprint, Fix Versions etc.

• You can set Y axis to be any parameter like number of issues, sum of remaining estimates, average of story points etc.

• You can group your data on any field(Sprint, Status, Assignee, Component, Project etc.) you want.

• You can choose various date ranges like All dates, Last year, Last 90 days, Last 30 days etc.

• You can modify existing Segments or add new segments.

• You can order the results by drag and drop.

Below you can see an article about creating custom reports, charts and graphs in Jira with our app.

How to Create Custom and Flexible Reports, Charts and Graphs in Jira

Here is our live demo dashboard where you can see and modify sample reports and play with them.

Hope it helps.

[paul carlson]

Thanks for this.  I will be able to present this in our meeting we have on how to better report the time spent on bug triage.

[paul carlson]

I just looked at the sample reports, will play around with these, thanks really appreciate it.

[Lisa Forstberg]

Hi @paul carlson ,

Welcome to the community!

Some questions to start with

• Is this 50-50 goal for the whole team, a sprint or for each individual developer?
• Are you adding both bugs triage work and new feature development to the sprint?
• I assume you have issuetype Bug and Story to categorize these work types? Do you use other types also?
• When you say TIME, are all individuals logging time on each issue or are you basing "spent time" on any other field, like estimate..
• I see you are on premium, do you have any addons like Tempo or EazyBI to extend functionality around time logging and reporting?

OOTB there isn't too much reports on time logging or generally calculating %. There are plenty of addons on the atlassian marketplace that extend the features in this area.

best regards

Lisa

[paul carlson]

Hi Lisa,

Yes we have separate bugs for all our production issues. so what where this comes from is when we did our PI planning, leadership wanted our team to spend 50% on bug work and 50% on feature, we had recently release a big project to production.

So I was hoping with either Automation or JQL a formula could be written to give me the % based on developer.

We have tasks created where the devs will log work in the time spent section, then at the end of the sprint we have to manually calculate the % logged on bug triage.  Personally I hate do manual calculations when there is all this technology out there.