Creating a gadget that shows last time a ticket was assigned

David Mortimer
Contributor
March 16, 2023

I'm looking to create a gadget that will show when they were last assigned a ticket. 

I have a list of 11 names that are on a rota based system for assigning tickets too.  Currently I have a google sheet as below 

PM NameIM NumberAssignment Date
MichaelIM7453/6/2023
SteveIM3983/8/2023
JoeIM3263/8/2023
PhilipIM6853/9/2023
DavidIM0683/9/2023
SarahIM5093/9/2023
JoanIMI9023/13/2023
BillIM5143/13/2023
JamesIM3953/14/2023
KeithIM3763/15/2023
AllanIM4253/15/2023

I have created a very simple filter to show all tickets assigned from start of the year, but just want a view that shows when the last ticket was assigned. So just have the 11 people with the date of their last ticket 

 

Hope this makes sense 

4 answers

1 accepted

Suggest an answer

Log in or Sign up to answer
1 vote
Answer accepted
Aaron Geister_Sentify
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 16, 2023

I typically use custom charts for Jira to build these types of charts/ widgets for Jira dashboards. I use custom charts for Jira add-on as it does present to an audience in a very nice way. 
The other option is to build a filter as stated. 

Mary Agueros
Contributor
March 16, 2023

👍

0 votes
Chris Iacovelli
Contributor
March 16, 2023

Does it need to be presented in Jira? Can you employ a confluence page with a Jira Macro per assignee to return the info?

only 1.png

0 votes
Pasam Venkateshwarrao
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.
March 16, 2023

Hello @David Mortimer 

 

you can use Filter sumup gadget

David Mortimer
Contributor
March 16, 2023

Pasam, I don't see the option in available gadgets  

Pasam Venkateshwarrao
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.
March 16, 2023

Hi @David Mortimer 

 

Please see the screenshot

 

Screenshot 2023-03-17 at 10.37.23 AM.png

0 votes
Juan Carlos Vera
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.
March 16, 2023

Hewllo @David Mortimer 

Can you Show the code of the JQL filter?

David Mortimer
Contributor
March 16, 2023

project = ESM AND issuetype = RCA AND "Assignee Date" >= startOfYear() 

TAGS
AUG Leaders

Atlassian Community Events