How get create a table of issue counts for each reporter in a list?

Lawrence January 27, 2021

I know how to pull individual reporter's issue on the following query.

project = NI AND issuetype = "Defect TRACKER" AND created >= 2021-01-01 AND created <= 2021-01-15 AND reporter in (user_id_1, user_id_2, user_3, user_id_4)

The query generates a list of all the issues for all the reporters. How do I get the following reports instead.

 

Reporter                  |  Issues |

name of user_id_1   |    10    |
name of user_id_2   |     8     |

name of user_id_3   |    11    |

name of user_id_4   |     9     |

 

Please advise.

 

Thank you,

Lawrence

 

1 answer

1 accepted

0 votes
Answer accepted
KAGITHALA BABU ANVESH
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.
January 28, 2021

Hello @Lawrence ,

 

Try Two dimensional Gadgets on dashboards.

with the created JQL, 

X Axis - Reporter

Y Axis - Reporter 

image.png

is it matches your need.

 

Thanks

Lawrence January 29, 2021

Hi Anvesh,

 

    Thank you for your suggestion.

 

    However, it appears the version of Jira that I'm using does not support 2D-statistics.  Attached is the  error message that pops up when attempting to add the gadget.  Is there an alternative to the the 2D-statisitcs approach. Please advise.

 

Thank you

 

Lawrence2D_Statistics.PNG

Lawrence January 29, 2021

Hi Anvesh,

 

     I don't know what happened before. But, I just try it now and it works.

 

     By the way, is there a way to change the heading of gadgets name "Two Dimensional Filter Statistics: 2D-Stat" to something else?

 

     Thank you for your time and help.

 

Regards,

 

Lawrence

Suggest an answer

Log in or Sign up to answer