Numeric Card gadget for Jira Dashboard

[Lucas Ferreira]

Hey all!

I was wondering if there is a gadget for Jira dashboards in which I could display a 'random number' for a determined filter/JQL I build... similar to those numeric cards we can build in PowerBI or any other BI tool?

For example: a query for number of bugs in current sprint, let's say... 8, then this number would apear in a card/balloon on the jira dashboard (I'm aware I can generate a list of them by using the "Issue Statistics" or the "Filter Results" standard gadgets in Jira dashboard, but I'd like to only show a big number, you know what I mean?"

Is there any gadget like this? Preferably for free? 

I'm currently responsible for a few KPIs in my current project, and all of them are based on JQL (to get the values), however I'm reporting them on a Google Sheets... It would be much better if I could use Jira Dashboard for that!

[Danut M _StonikByte_ · Accepted solution]

Hi @Lucas Ferreira,

As far as I know Jira does not provide such gadgets.

But this can be easily done by using some of the gadgets offered by our Great Gadgets app.

For example, with the Issue Filter Formula Gadget you can display the COUNT, SUM, MIN, MAX, AVERAGE etc for the issues and a numerical field of these issues from a filter or JQL.

You can show the result as a big number:

 

... or as a gauge chart:

In addition, with the Advanced Issue Filter Formula gadget offered by the same app you can calculate and display any math formulas, percentages, rations, etc by combining the issues from up-to 6 filters. 

The app offers also a Pivot Table & Pivot Chart gadget plus many other that you will find useful. And it is fully localized in PT. 

Find more about these gadgets in these articles: 

https://community.atlassian.com/t5/App-Central/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369

https://community.atlassian.com/t5/App-Central/How-to-track-scaled-agile-SAFe-projects-in-Jira-with-Great/ba-p/1929694

This app is free with the Jira free plan (up-to 10 Jira users). Otherwise, you could start with a free 1-month trial.

If you have any questions, feel free to contact us at support@stonikbyte.com.

Hope this helps.

Danut.

[Lucas Ferreira]

@Danut M _StonikByte_ thank you so much for your reply, that looks exactly what I need!

With that gadget, am I able to pull a big number with the sum of the story points within a determined amount of tasks? Or even do calcs like % of Points Commited / Points Completed within a sprint?

[Danut M _StonikByte_]

Hi @Lucas Ferreira,

Yes. Both gadgets can calculate the SUM of Story Points for the issues in a filter.

The Advanced Issue Filter Formula Gadgets allows you to calculate percentages for issues in multiple filters. 

For percentages like the one you mentioned, you could also use the Pivot Table & Pivot Chart gadget and the Team Velocity gadget offered by the same app. 

Danut. 

[Lucas Ferreira]

@Danut M _StonikByte_ awesome! I'll give it a try! Thanks again!

[Lucas Ferreira]

@Danut M _StonikByte_ would you know what JQL would I use to bring the SUM of story points commited to a sprint and another for the SUM of story points completed on that same sprint?

[Danut M _StonikByte_]

Hi @Lucas Ferreira,

If you need historical data (for past sprints) use the Team Velocity gadget; it does not require a JQL, you just select the board instead.

If you want these numbers for current sprint, try something like this:

For committed (actually, current scope) - you need a JQL that returns all the issues from the sprint

sprint = "Your Sprint Name or Sprint ID"

For completed - you need a JQL that returns all the issues from the sprint that are in the statuses  mapped on the last column of the agile board (so look at the Board Settings > Columns)

sprint = "Your Sprint Name or Sprint ID" AND status IN ("Closed", "Done", ... etc)

Hope this helps.

Danut.

[Lucas Ferreira]

@Danut M _StonikByte_ but let's say the sprint had its scope changed a bit (issues being added and removed), then the JQL to return issues from the current sprint wouldn't be correct (for committed), isn't it true?

[Danut M _StonikByte_]

@Lucas Ferreira Yes, you are right. But I'm afraid that this cannot be achieved by a JQL. The JQL always returns the current story points; you actually need the story points at the start of the sprint, which is not possible with JQL.

For this type of info you could use gadgets like Team Velocity or Sprint Burndown Burnup Chart, which use advanced processing for determining the story points at the start of the sprint. 

Danut.

[Lucas Ferreira]

@Danut M _StonikByte_ I figured... but thanks again, that app is amazing anyway!