How to display 3 projects in a Dashboard and group per sprint

Question

Hello Community,

Project One uses sprint naming convention: One 24 SP1, One 24 SP2, One 24 SP3, etc

Project Two uses sprint naming convention: Two 24 SP1, Two 24 SP2, Two 24 SP3, etc

I would like to create a dashboard and show the story points per sprint (Project One and Two the same sprint number)

Overall Statistic

SP1 100 points <== total of all sprints from One 24 SP1 and Two 24 SP2

SP2 100 points

etc

Any advice on how to create this JQL?

Thank you!

Marlene Kegel - codefortynine · Answer

Welcome to the community, @Ann Gerilyn Lam.

I am Marlene, product manager of Quick Filters for Jira Dashboards.

If you are open to work with a Marketplace app, you can try our Jira cloud app.

For your use case I would recommend the "Quick Bar Chart" gadget which can sum up story points and any other Jira number field.

In the gadget you could also configure "Custom JQL Values" for every bar which is shown on the gadget. You could configure them like that:

* Sprint in (One 24 SP1, TWO 24 SP1)
* Sprint in (One 24 SP2, TWO 24 SP2)
* ...

Another option would be to work with the "Quick Issue Statistics" or "Quick Two Dimensional Filter Statistics" gadget to sum up story points.

You can try Quick Filters for Jira Dashboards without installation on our demo dashboards.

Tomislav Tobijas · Answer

Hi Ann,

As already stated, native Jira gadgets within dashboards won't be able to provide desired results as you won't be able to group and sum values from different sprints with the same suffix in the name.

I would check Atlassian Marketplace for this specific request and try out apps to see if any of them can achieve this. We're using Custom Charts for custom reports but I am not sure if what you asking is possible with current app features. I'm guessing you would need some table/chart gadgets that support some kind of formula columns that would be able to parse out the name and then sum up the values based on the criteria but I'm afraid that this use case might be a bit too stretched. Potentially connectors such as the one for Power BI or similar could be of some help here.

Cheers,
Tom

Danut M _StonikByte_ · Answer

Hi @Ann Gerilyn Lam,

I'm afraid that this is not possible with Jira's native gadgets or JQL. As long as you have different sprints for the two projects, the Jira gadgets cannot aggregate the data between them.

One option would be to have one agile board for both projects, so one sprint including the issues from both projects.

If this is not convenient for you, another option would be to search on Atlassian Marketplace for a plugin that offers a gadget that is able to aggregate data.

If you consider the idea of using a plugin, our Great Gadgets app offers a Pivot Table & Pivot Chart gadget that can resolve your problem but with the condition to have the same name for the sprints across projects. So you will have to rename the sprints like this:

Project One sprint naming convention: SP1, SP2, SP3, etc

Project Two sprint naming convention: SP1, SP2, SP3, etc

So you will still have separated sprints for projects, but they will have the same name.

With such a configuration in place you will be able to aggregate the data like this:

If you need any help with the configuration of this gadget, feel free to contact support@stonikbyte.com.

Danut.