Chart is showing issues that are not part of the control "fix version"

[Johanna Hurtado Morales]

Hi everyone, 

I am using a chart to count (distinct) the number of stories, bugs,etc included in a specific release (Fix Version). However, when I select a Fix Version from the control, the chart shows more than 2,000 issues, including issues that do not have that Fix Version selected and even including issues with null fix version.

I expected the chart to return only the stories, bugs,etc which are only 11 issues that are explicitly associated with the selected Fix Version.

Could someone please let me know what configuration or setup I might be missing?

Thanks :)

[Johanna Hurtado Morales · Accepted solution]

My co-worker and I found the way to do it

[Arkadiusz Wroblewski]

@Johanna Hurtado Morales  Glad it solved. That´s most important.

[Arkadiusz Wroblewski]

Hello and welcome to the Community @Johanna Hurtado Morales 

Based on your screenshot, this is a query setup issue rather than a chart bug.

Since the results table already shows 2284, the KPI card is just doing its job, the data coming into it is what's actually wrong. The likely culprit is the {RELEASE_NAME} filter. Release names aren't unique across Jira, so your query is probably grabbing tickets from every project that happens to have a release with that same name.

To fix this, I'd recommend switching your control to use "Version ID"  instead of Name, or simply adding a Project filter to narrow things down. If you want to see exactly where those extra tickets are coming from, add "Project Key" and "Version ID" as columns to your result table temporarily. You can also peek at the generated SQL to see exactly how the joins are behaving. Seeing those IDs usually makes the fix pretty obvious.

[Johanna Hurtado Morales]

Hi @Arkadiusz Wroblewski thank you so much for your response. I checked in Jira and only 11 issues have the release name I am using, I filtered as well by the project and still bringing the same 2284 results.

Additionally, I checked the issues that were part of the result, and I can see those issues do not have any fix version that's why I was filtering as well that release name is not null.

I am going to try what you suggested to use the version id to see if that works. I think the issue is when crossing the main issue table "work item" to "Project" and "project fixed version" thanks :) 

[Johanna Hurtado Morales]

I just tried using the version ID still brings the same 2284 issues