Gadget Two Dimensional Filter Statics. Not all states appear

[Luis Alberto Vazquez]

When I configure the gadget with a filter and put the status on an axis, only two states appear to me, the first state is correct the issues that come out, but the second is a sum of the other states. Do you know why it happens? I have version 7.3.8 of jira, we have a development environment with the same version and the gadget works correctly. 

Thanks for your help !

[Luis Alberto Vazquez]

I have 12 states in the workflow and the filter that I use is simple would be "project = AAAA".

XAxis STATUS
YAxis Priority
Sort By Natural

When I save it, the IN PROGRESS status appears with the correct number of issues and the READY TO VERIFY status with the sum of the issues of the other states (New, Accepted, Blocked, Resolved....).

[Ignacio Pulgar]

May you possibly attach a screenshot of the gadget so that we can see the wrong results?

[Luis Alberto Vazquez]

The query project = AAAA AND issuetype = Story AND status = "Ready To Verify" ORDER BY status DESC gives 13 results and not 125

[Ignacio Pulgar]

That's really weird...

May you reindex project AAAA and refresh the dashboard page?

[Luis Alberto Vazquez]

Reindexe jira varias veces. Porque sucede para todos los projectos de jira no solo para el proyecto AAAA

[Ignacio Pulgar]

I'd recommend opening a ticket with Atlassian Support with a description of the issue (and maybe a link to this question):

https://support.atlassian.com/contact/#/

In the meantime, may you run the Integrity Checker and see if it returns any errors?

<your Jira URL>/secure/admin/IntegrityChecker!default.jspa

[Luis Alberto Vazquez]

Thank you very much. I've already opened the ticket

[Ignacio Pulgar]

You're welcome, Luis!

Once you fix the issue, please, update this question with the answer so that other users with the same problem can take advantage of your research.

Best regards!

[Ignacio Pulgar]

By the way, what's the JQL shown after clicking on the number 125 from your screenshot?

[Ignacio Pulgar]

Besides, may you go to admins Cog icon > Issues > Statuses and look for Ready To Verify?

Maybe you have two statuses with similar names... therefore getting different results depending on the actual Ready To Verify status the query might be using.

[Nic Brough -Adaptavist-]

Now I don't understand what is wrong.  If the field is showing "ready to verify" and it's a single status in the workflow, then it's showing you the number of issues in that status.  I'm lost on what the error is.

Could you give us an idea of the gadget configuration?  The filter it is looking at, and what the fields for the two axes are?

[Luis Alberto Vazquez]

The label for the sum of the state issues is the name of a state (Ready to verify) of the workflow. When you click on the number, the query appears in the filter and here you can see the number of issues in that state (Ready to verify) 

[Ignacio Pulgar]

Hi Luis,

Maybe the other axis is based on a field that accepts multiple values (ie: components, labels...) and there are some issues with several values being retrieved by your filter.

Because of that, the values are being counted as many times as they are true for that Status and multivalued field, therefore showing apparently incorrect results.

Hope it helps.

[Ignacio Pulgar]

Let me give an example.

I've saved a filter which returns just 1 issue, and that issue has 2 labels: 'a' and 'b'.

I've set a two dimensional gadget with Status and Labels using that filter, and this is the counter-intuitive result:

Is that a similar case?

[Nic Brough -Adaptavist-]

What does the label for the second one say?  The one that is a "sum of the other states"?