Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Is there a way to get the time logged per person across projects?

Hi,

I have several projects being handled within my group and I would like to get the time logged across projects.  I need this report to be created weekly and per person.

Is there any plugin or any tool that I can use to create this report?

Asha

 

 

3 answers

1 vote
Stuart C Community Leader Feb 06, 2021

Hi @Asha 

I have a report set up for a similar purpose using Jira Cloud for Sheets

You can also export to Excel if you prefer but I like Google Sheets as you can set up a scheduled refresh, bring in the fields you need and then create whatever reporting you need that will update for you automatically.

To get started you can go to 'issues' and do an advanced search to start you off, and then you'll see the options to export to Excel or Google Sheets. You'll need to authenticate but it will guide you through the setup process and from there you can set up a schedule to refresh the data.

Capture.JPG

There's lots of different add-ons available on the marketplace so it's worth searching on there as well. Some might require an additional subscription fee which is I like the free G Sheets option.

You can use tempo timesheets, it let you group by user and project, or EazyBI

@Asha surely the solution proposed by @Manuel Galván  is the best for now: because your data remain inside a Jira-centric system that doesn't disperse the knowledge as it happens if you switch to google sheets or excel or microsoft powerbi for example.

0 votes
Stuart C Community Leader Feb 08, 2021

Hi @Kalos Bonasia ,

 

The business requirements were for a report to run weekly.

Tempo and easyBI are great products but buying either would be like taking the kids to school in a Ferrari if all you need is a weekly report.

Add-ons will cost extra but provide additional benefits. With sheets you can schedule an update of the data set hourly so whenever you go to the report you've set up it is up to date (or refresh it to the latest data within seconds).

I understand @Stuart C then why not try this from Old Street Soltutions ?

https://marketplace.atlassian.com/apps/1220925/custom-charts-for-jira-reports?hosting=server&tab=overview

I am convinced that taking data out of Jira, if the data is in Jira, is a less efficient way to make a report.

Stuart C Community Leader Feb 08, 2021

Absolutely - perfectly acceptable solution. It looks like a very good price actually and I might well try it out on my private instance.

I think you're probably right - but if your use case calls for effectiveness over efficiency then you have to consider other options right?

Giving a third party access to the REST API of your Jira instance isn't a preferred option in some use cases.

It's good that @Asha has number of different options to look into though. Thanks for your input @Kalos Bonasia

Hi, @Stuart C thank you for the feedback. @AshaIt's great to E-meet you. I'd love to connect and jump on a live demo if you're available to show you what Custom Charts has to offer and can solve some of your pains. Are you available on February 12th, 2021?

 

Thank you @Kalos Bonasia Thank you for the recommendation of Old Street Solutions - Custom Charts 

Like Kalos Bonasia likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you