Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

Get Workload Pie Chart Report Data From REST API

Edited

I've seen a couple scattered Atlassian Community questions about similar things, but nothing addresses the exact situation I am in.

I need the data from the Workload Pie Chart Report for a Jira project via the Jira REST API.

I have tried using the JQL queries for each section of the pie chart along with the search API endpoint. I set the `maxResults` parameter to zero using the advice from this article to get the total number of issues (via the `total` value) from the query without having it return any actual data about the issues (which seems to make the API response much faster and use less data).

However, this unfortunately isn't exactly what I need; I need the hours-spent value from each issue, summed up into a single metric for each pie chart section. This is with the end-goal of using chart.js to build my own chart inside a custom Microsoft SharePoint web part, if it matters.

One way to do this is to get every issue from the JQL query for each pie chart section via the API, get the issue's hours-spent value, and compute the aggregate sum in my programming language. That is not feasible though, primarily because the API caps the amount of issues that it returns for a query. Even if it did return the full, accurate amount of issues along with their data, paginating through them and doing the sum manually via the API would take an eternity and I'd probably get rate-limited, haha. So that is not a feasible method.

I've heard something about a Jira SQL database as well... that sounds moderately promising for a fast enough computation and ease of querying. I don't actually know if that exists though, or if it would even be accessible via API (edit: after more research it seems the SQL is only available on Jira Data Center, not Jira Cloud). I've also heard about an app called ScriptRunner and it seems to offer extended JQL functionality per its description. Maybe that's a possibility?

If anyone has any advice on how I can accomplish this, via JQL or another method, that would be much appreciated.

2 answers

If you are up to using some app, you can consider using eazyBI for different metrics and reporting. We support different reports for time tracking by default.

We do not have support for publishing reports in Sharpoint, though. You can check if the iframe could work.

We have the option to access any report via REST API as well. You can build a report to get the data grouped as needed and then access the report via RES API and integrate the results of the reports in any system.

 

Daina / support@eazybi.com

Unfortunately I don't believe iframes are supported in SharePoint. Thanks for your response, though.

Hello @cball 

Unfortunately, there is no easy way out. You are just going to have to bite the bullet and use a properly constructed JQL search to get all the issues that you need, then do all the summing of the time spent per issue and constructing the pie chart in your app. If you have to deal with a large data set that is paginated and needs to downloaded in batches, then so be it.

The REST API just isn't designed to do any of that pre-preparation work for you... it just provides data. Remember, don't do open ended, unconstrained searches and you won't hit the rate limits; only search for what you really need.

If you want to avoid the development overhead of this approach, 95% of the time you'll find you can solve the reporting problem with an off the shelf reporting tool for Jira or Confluence, and they are reasonably priced.

Yeah, this is unfortunately what I expected. Thanks for your response!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

612 views 21 25
Read article

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