When using two dimensional chart Jira macro, can I show sprint data across multiple projects?

[atla pani]

I have several projects that use the same sprint label, such as "2023_12". When I create a two-dimensional chart, I set the x-axis as the sprint and the y-axis as the project. However, when I run the report, it displays all the projects correctly, but it shows multiple columns with the same sprint name - one column per project. I would like to filter this view to show only one column for a particular sprint. Can you suggest a way to achieve this?

[Laurie Sciutti]

Hi @atla pani and welcome to the Community!  Sprints are stored in the DB as an ID (numerical) rather than as text so when you report on it, even though the sprint "name" may be the same, they are still considered different sprints.  This is by design so that teams in one project can name their sprint the same as a team in another project.  

That said, I'm not sure you can distinguish that in the 2-dimensional filter Jira macro.  One solution (though not pretty) may be to create an automation that adds a label to issues with the same sprint name then report on that label (instead of the sprint).  HTH but I'm curious if anyone else has another approach to this....