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:
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:
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.
This is exactly why Atlassian needs to be more supportive of database access and provide far more documentation about it. 30-year DBA here ...