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!
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:
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.