Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

Anova Apps Marketplace Partner Feb 21, 2020

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.



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:


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

Kat Marketplace Partner Feb 23, 2020

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


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

Marketplace Partner Spotlight: AppLiger

This month the spotlight is on AppLiger. We caught up with Pavel Pavlovsky, CEO and Product Manager, to learn how the company started and what fuels the team's creativity.    Atlassian:...

389 views 0 7
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