filter results dashboard widget not matching with count of field in issue statistic dashboard widget

Apoorva Mallepally

tried to add 2 widgets on dashboard:

1. shows filter results of a saved filter

2. shows issue statistic view with statistic type as a particular field on the ticket against the same filter as mentioned above.

 

Issue: the count displayed on widget 2 doesn't match with count of issues that the filter is displaying in widget 1. 

saved filter is in this format: project = "####" AND created>=-2d AND ((text ~ ## OR text ~ "###") OR (text ~ ### OR text ~ "####") OR (text ~ "###" or text ~ "###") OR (text ~ "####" or text ~ "###") OR (text ~ "####" or text ~ "####") OR (text ~ "###") OR (text ~ "##" or text ~ "###" or text ~ "###") OR (text ~ "####") OR (text ~ "###") OR (text ~ "##### ") OR (text ~ "###") OR (text ~ "###" or text ~ "####") OR (text ~ "###" or text ~ "###") OR (text ~ "###")) AND (labels != "###" OR labels is EMPTY) OR labels = ### order by created asc

 

Widget 1 needs to display how many tickets created have missing labels as intended in the filter above and display the count of filter results grouped by the squad name.

 

i am not sure if i am doing this wrong or there is a JIRA defect for this?

 

Bill Sheboy

Hi @Apoorva Mallepally -- Welcome to the Atlassian Community!

Short answer

As you have concealed quite a bit of your dashboard image and query, it is unclear what is happening.  I recommend you discuss this with your Jira site admin as you can show them the details of what you are trying and they can likely help.

 

Longer attempt at answering

It is unclear if you are using the same filter and criteria for those two dashboard gadgets.  One thing is definite: there appears to be a problem with your query, based on what you described.

If I reformat your query to make it more readable, we see this:

project = "####"
 AND created>=-2d
 AND (
         (text ~ ## OR text ~ "###")
      OR (text ~ ### OR text ~ "####")
      OR (text ~ "###" or text ~ "###")
      OR (text ~ "####" or text ~ "###")
      OR (text ~ "####" or text ~ "####")
      OR (text ~ "###")
      OR (text ~ "##" or text ~ "###" or text ~ "###")
      OR (text ~ "####")
      OR (text ~ "###")
      OR (text ~ "##### ")
      OR (text ~ "###")
      OR (text ~ "###" or text ~ "####")
      OR (text ~ "###" or text ~ "###")
      OR (text ~ "###")
     )
 AND (labels != "###" OR labels is EMPTY)
 OR labels = ###
 order by created asc

And you stated that:

Widget 1 needs to display how many tickets created have missing labels as intended in the filter above and display the count of filter results grouped by the squad name.

If you review the last lines of your query with the several tests on labels, you may find it does not work as you expect.

I suggest recreating your query, step by step to validate the results.  And only after it works as expected to then try using it with a dashboard gadget.

Kind regards,
Bill