Tempo how to Summarize hours on epics

Hi.

is there any way in tempo reports or export, to summarize hours spend on story's belonging to an epic and thereby the epic "holds" the total number of hours?

7 answers

1 accepted

3 votes
Answer accepted

Oh yes i'm quite aware of that possibility, but it's realy not an option. So i'm looking forward for youre soloution

No problem. Care to tell me why it is not an option? It would be great to get the feedback.

Hi, I'm new to Jira and Tempo, so forgive me it this function now exists as I appreciate that this request is quite dated now. Like Bjarne has outlined above-

we too also use Epics as placeholders for tasks/story's belonging to specific stakeholders. It would be great if tempo had some sort report or export option, that would summarize hours spent on stories belonging to an Epic?

I realise that this question was posted some time ago now.. You mentioned that the team were adding a lot of more reporting functionality in this area in upcoming versions. Does this functionality now exist? Thanks

For Us is quite important too. Is there any way to group tempo report by epics? 

@Sebastian Ovide but only one epic at a time? when you have more than ten then we need 10 custom reports? Am I right? It would not be grouped by epics but only show the list of task in specific epic or list of epics? 

@Sebastian Ovide so I can only see the number of hours for one epic in a time? Is there any chance to see the list of epics and summarized hours for each of them? I have 10+ epics and what I can only do to summarize them into excel :( 

what about creating a filter ? or a tempo account ?

Still no update from Tempo on this. It really does seem fairly fundamental so I don't understand why they keep ignoring it.

We had a UX update today but its all fairly pointless when you can't get a list of EPICs with the time that has been logged against them 

I have been using Pivot Report to plug this obvious feature gap. Yes, not the same as you can't see the time logged for Epic within given time frame, but is something.

https://marketplace.atlassian.com/apps/1215414/pivot-report?hosting=cloud&tab=overview

Correction, you can actually get the summary of time spent on Epic now per time slice!

That looks promising. A quick question. Does it pull out the Tempo hours logged?

What we need is something like the below. 

We then need to be able to filter on particular months (i.e. the below would be for Dec)

 

Epic Name                        Hours Logged

Epic 1                                10.3

Epic 2                                50.7

Epic 7                                02.4

Since Tempo uses same Jira worklogs and extends them with custom meta data, it does pull out hours from Tempo. If it won't work, please let me know, and we'll do our best to fix it.

Hi,

There is no nice way to do this at the moment. But you can create a filter that returns the Epic stories and view that filter in Tempo Timesheets.

IS there any change this will be implemented in a future release?

we use epics as placeholders for tasks/story's belonging to specific customer, we track time to evaluate time spent, cost towards the original estiamte. And This would be more than nice if we could do that within a standard report

Actually I am looking into solutions to this now but it is still in the design phase.

However, I hope you are aware that Tempo comes with a Account Custom Field that can be used to represent customers and has built in reports for this purpose. So you might want to have a look at that to get this report today. You can still continue to use epics and simply add the customer association to the issues.

It will be nice if there is such a feature implemented soon. It is very inconvenient that there is no easy way to see the time spent on an Epic now, and I need to use Tempo stats per filter.

Hi Ivaulo, you can use the Agile Timesheet filtered by epic to see total hours per epic. We are adding a lot of more reporting functionality in this area in upcoming versions.

today we have appox. 100 accounts and still growing, and that is a problem by itself, since we can't sort the billingkey dropdown by name instead of the number and thereby make it easy for the ones who create issues. But back to the case here, we have arround 60 epics that we would like to report statistics on a monthly basis (comes with the invoice) so togehter with the already excisting accounts it would be a mess for everyone

So I assume you are mapping the 100 accounts always to the same projects or you define them to be global? Normally we have only a handful of accounts per project so the dropdown is usually not a problem for us. However, we are working on improving the dropdown for extreme cases.

This maybe old news by now, but I've been able to add the field "Epic Link" to the tickets, and with that select the epic I want to associate the ticket to. Then I can view the epic in tempo and all the associated tickets will show up.

Hi Ben - thanks for this post. 

We use Epic links extensively in our JIRA issues, and it does look like I can include individual epics as a filter in a Tempo custom report.  However, I don't see a way to group by Epic.  So, if I included multiple Epics in the filter, for instance, that rolled up time just shows up under the user or project or whatever I have in the groupings and I couldn't tell what Epic that time actually belonged to.

So, when you say you can view the Epic in Tempo, how do you do that?

Doesn't appear to be a way to group by Epics if you have multiple Epics filtered unfortunately.

Thanks for the reply.  I just wanted to make sure I wasn't missing anything, but it is great that you can at least filter by Epics in the reporting screen.

Also, as mentioned by Viðar Svansson above, looking at a basic timesheet in the Agile Timesheet does allow you to roll up time by Epic.  So, that is really handy if not as flexible as the reporting module.

Inability to group time-sheet reports by epic or by issue rolling up all the hours from child issues, make TEMPO reports useless.

Like 2 people like this

i can't seem to find the "agile timesheet". i also could not enable is in the tempo settings - i can't find it there. do you know how do you find the agile timesheet?

@Vidar Svansson

Is there any update on this feature? This has become fundamental to our business so I just need to know if there is even a time frame or if its on a product roadmap. 

We (and a number of other people) have requested this multiple times. If it isn't possible, please let us know and we can look at alternatives.

The end result we are after is below. 

 

Epic Name                        Hours Logged

Epic 1                                10.3

Epic 2                                50.7

Epic 7                                02.4

Hello Paul,

 

You can try Pivot Report for that: https://marketplace.atlassian.com/apps/1215414/ 
I understand it's another app you need to pay for, but it least it does the job you need. 

 

If something in Pivot is not working as it should, please let me know. We try to fix everything ASAP.

Thank you Dmitry,

I have installed the pivot report and it almost gets me there but it still won't give me a full list of rolled up epics.

I can get one epic by using JQL request and referring to that epic ID but how would i get all EPICS? (i have logged a support ticket but no response as yet)

It  needs to end up something like the below

 

Epic Name                        Hours Logged

Epic 1                                10.3

Epic 2                                50.7

Epic 7                                02.4

Hello Paul,

Have you tried to get more than one epic per search? E.g. somewhat like "project = ProjectName and issuetype = epic"? If you use these results for the report, you'll have multiply Epics in it. Here's an example:

The view you need is on the Pivot tab. I've used Epic Link to group time spent. 

I can get  a report like this to show time spent on each ticket under my epic grouping.  Is it possible to summarise all the time spent for all tickets on an epic and display it against the epic?

Don't worry found it "E Time Spent"

Like 1 person likes this

Hi Paul,

Yes we are planning this now. Are you on cloud or server?

We are cloud server. 

Suggest an answer

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

Updates to jira.atlassian.com give you visibility into what's coming in Jira Server and Data Center

Hello, Community! My name is Gosia and I'm a Product Manager on Jira Server and Data Center here at Atlassian. Since 2002 when we launched our public issue tracker, jira.atlass...

407 views 1 13
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