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

Ann Gerilyn Lam
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 24, 2024

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!

4 answers

0 votes
Marlene Kegel - codefortynine
Atlassian Partner
October 29, 2024

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. 

quick-filters-jira-dashboards_bar-chart_story-points-sprint.png

 

0 votes
Tomislav Tobijas _Koios_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 25, 2024

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

0 votes
Danut M _StonikByte_
Atlassian Partner
October 24, 2024

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:

image.png

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

Danut. 

0 votes
Vronik
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 24, 2024

Hi

You can create a filter like this
project in (ProjectA, ProjectB) and sprint in openSprints()

Then you create a dashboard with that filter and of course you can add more things that you need

Look at this article, maybe can help you

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/

Regards

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events