Creating a gadget that shows last time a ticket was assigned

[David Mortimer]

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 Name	IM Number	Assignment Date
Michael	IM745	3/6/2023
Steve	IM398	3/8/2023
Joe	IM326	3/8/2023
Philip	IM685	3/9/2023
David	IM068	3/9/2023
Sarah	IM509	3/9/2023
Joan	IMI902	3/13/2023
Bill	IM514	3/13/2023
James	IM395	3/14/2023
Keith	IM376	3/15/2023
Allan	IM425	3/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 

[Juan Carlos Vera]

Hewllo @David Mortimer 

Can you Show the code of the JQL filter?

[David Mortimer]

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

[Pasam Venkateshwarrao]

Hello @David Mortimer 

you can use Filter sumup gadget

[David Mortimer]

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

[Pasam Venkateshwarrao]

Hi @David Mortimer 

Please see the screenshot

[Chris Iacovelli]

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

[Aaron Geister _Trundl_]

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]

👍