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 DateMichaelIM7453/6/2023SteveIM3983/8/2023JoeIM3263/8/2023PhilipIM6853/9/2023DavidIM0683/9/2023SarahIM5093/9/2023JoanIMI9023/13/2023BillIM5143/13/2023JamesIM3953/14/2023KeithIM3763/15/2023AllanIM4253/15/2023I 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

Creating a gadget that shows last time a ticket was assigned

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

4 answers

1 accepted

Suggest an answer

1 vote

Answer accepted

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.