The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results forĀ 
Search instead forĀ 
Did you mean:Ā 

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

Lawrence
Contributor
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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

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 Champions.
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
Contributor
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
Contributor
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