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
Highlighted

Raise your hand if you've ever been beyond frustrated with OOB reports in Jira.

All of you? Great. I get it. I can't tell you how many times I needed to write JQL queries, export to Excel, and then create pivot table or charts. But then be slapped with the realization, "Oh wait, I can only export a maximum of 1,000 entries at a given time." Ugh. So I either do the export in batches, or use REST API to paginate the results.

_______________________

I'd be left there staring blankly at the screen, reflecting...

Can I do this all this manual work? Yes...but at what cost...

Do I want to do all this manual work? No, not really...

____________________

I had to look into other options. Like Power BI and Tableau. Can I create sleek charts that shows everything that I need? Yes, but OH MY G - not for that price. *closes all tabs

Pivot. Surely the Atlassian Marketplace would have an option that would preserve my sanity, right? I downloaded 1, 2, 3, 4 plugins to see what they offered. I checked all the features, rechecked them, and rechecked the rechecks. Disappointment was sinking in... please don't send me back to Excel...

 

So to help you avoid this pit of despair, I present:

Power Dashboard Reports Charts & Gadgets

With this product, you can aggregate data and customize charts the way you want while centralizing all your reports in Jira. Just a few lines of SIL® code can design an array of visualizations that displays all the metrics you desire.

Here's a popular example:

Time in Status

Need to know the average time a ticket stays in a status? *keep in mind, this isn't from the ticket's perspective but from the status's point of view. Want to present in a bar chart? Done.

image2020-2-18_13-12-5.png

 

You can do more than just bar charts as well. Here's just a few more samples of chart types that are possible:

Time Series of Revenue for a Project:

Screen Shot 2020-02-21 at 2.01.25 PM.png

Pie Chart of Story Point Distribution Across Features:

chart2.png

What about calculating a 3 week moving average of resolved story points? Yes, that's possible. But what about - shhh, yes. Anything you can think of, Power Dashboards can do. 

You have a powerful tool at your disposal:

It's versatile. Grab data you want, calculate the way you want, and display the way you want. Shoot, if you want to create a function that calculates 1 + 1 = 3 then display that in an HTML dashboard, you can. You're the boss.

It's powerful. Since the add-on was created with flexibility and efficiency in mind, performance hit is minimal. Report all the things!

It's extensible. Because SIL can access data from anywhere, you can use data sources from external databases (AWS, Google Cloud, Azure, etc.) or other tools (Tempo, Jira Service Desk, Salesforce, etc.) to report on operational, financial, and development metrics.

1 comment

@Alexey Matveev _cPrime_ - is this guy on cPrime's payroll? If not, he has definitely earned some swag for this great article. 

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Do Not Lose your Customer’s Trust

Missing deadlines is one of the biggest problems every team lead wants to avoid when dealing with managed services. When the customer contracts your company to help with IT services it is expected th...

290 views 0 1
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