Problem with two dimensional Filter Statistics

Aurélie Pilette
Contributor
July 17, 2024

Hello,

I create a filter for which the total number of tickets is 116

When I use this filter to create a two dimensional filter statistic, the total is 72

I don't understand why I have a difference.

Please help me

 

 

 

4 answers

4 accepted

2 votes
Answer accepted
Aurélie Pilette
Contributor
July 18, 2024

Finally, I create a ticket to JIRA support and it is a bug which will be fixed !

Hans Polder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 18, 2024

Thanks for the update @Aurélie Pilette !

Good to know we weren't missing something obvious :)

0 votes
Answer accepted
Danut M _StonikByte_
Atlassian Partner
July 17, 2024

Hi @Aurélie Pilette,

See also this thread for a similar topic: 

https://community.atlassian.com/t5/Jira-questions/Two-dimensional-filter-statistics-display-bug/qaq-p/2698187

Also, Iit might be due to the way its handle the None values; see also this Jira bug: https://jira.atlassian.com/browse/JRASERVER-71132

Also, be aware that there is a better alternative to this gadget. You could try the Pivot Table & Pivot Chart gadget offered by our Great Gadgets app, which covers that gadget's functionality but offers much more.  Perhaps it displays the correct data.

image.png

Hope this helps.

Danut.

Aurélie Pilette
Contributor
July 17, 2024

My problem is the same as : https://community.atlassian.com/t5/Jira-questions/Two-dimensional-filter-statistics-display-bug/qaq-p/2698187 but I see that there is no solution and i don't understand why.

 

it is not the same than  https://jira.atlassian.com/browse/JRASERVER-71132 because I have no column as none

And I can't use your Pivot table because like we are more than 200 users, it is not free.

The two dimensional worked fine. So, it happens something that results are false. And I would like to understand what or if there is a bug in Jira Cloud.

 

Danut M _StonikByte_
Atlassian Partner
July 18, 2024

Hi @Aurélie Pilette,

In this case I recommend opening a support ticket with Atlassian Support team. I think they can help you with the troubleshooting. 

Danut.

0 votes
Answer accepted
Sreenivasaraju P
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.
July 17, 2024

Hi @Aurélie Pilette ,

 

Can you try to change the statistics of x-axis and y-axis and try. Whether it is giving same result for all parameters or not.

 

Please check whether you configured parameters like Fix for version (non archived), which will give requests of non archived versions only. 

Aurélie Pilette
Contributor
July 17, 2024

I try to change X and Y axis or change the parameters dans I have still the problem

0 votes
Answer accepted
Hans Polder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 17, 2024

Hi @Aurélie Pilette ,

My first guess would be that for the 44 tickets that are not shown, at least one of the fields that you want to show is not filled. Can you give an (anonymized) screenshot of the Widget (both in configuration mode as well as display mode)?

Aurélie Pilette
Contributor
July 17, 2024

Capture d'écran 2024-07-17 220346.png

Aurélie Pilette
Contributor
July 17, 2024

You will see my board configuration. But when I click on a line like pending : Capture d'écran 2024-07-17 220912.png

Aurélie Pilette
Contributor
July 17, 2024

I am redirected and I can see 3 tickets

Capture d'écran 2024-07-17 221010.png

Aurélie Pilette
Contributor
July 17, 2024

If I configure a simple Pie Chart with same filter by select status or squad ==> i have 116 tickets

Hans Polder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 17, 2024

Hi @Aurélie Pilette

Can you post the full JQL that you are using?

Can you also share the full picture of the 2dimensional table, with all columns visible? You might have to make the dashboard page-wide (no columns) for that to show correctly.

 

Aurélie Pilette
Contributor
July 17, 2024

2024-07-18_08h37_29.png

 

 

here, you will find the jql used : 

 project = SFRA AND sprint in openSprints() and sprint not in (340, 489, 548) and issuetype != Sub-task

So, do you find where is the problem?

Hans Polder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 18, 2024

The absence of the None column would indeed suggest that there are no tickets where one of the two fields is empty. As you mentioned in a different reply in this thread that it's an Atlassian-confirmed bug... I'm curious to what the bug exactly is. What are the steps to reproduce, as far as you know?

Aurélie Pilette
Contributor
July 18, 2024

They accessed to my dashboard. They recreated same configuration on their environment.

And reproduce. They said that there is an inconsistency in the data displayed on the gadget.

Like Hans Polder likes this
Dominic Fosson November 21, 2024

I ran into the same issue. As suggested above, I flipped the values that were displaying on the x- and y-axis and that seemed to do the trick; however, this format will be unusable given the amount of side-scrolling required to view all the data cleanly.

Knowing that flipping the axis does the trick, is there something I can do that would allow me to reverse them back and get accurate totals?

Dominic Fosson November 21, 2024

I found the solution to my issue: I just needed to increase the row count to ensure all the rows feeding that total number were displaying. On the gadget, click Configure , then under the Number of results field, increase the number until all your rows are accounted for (I believe it's capped at 50).

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events