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
Solved! Go to Solution.
project = ESM AND issuetype = RCA AND "Assignee Date" >= startOfYear()
Does it need to be presented in Jira? Can you employ a confluence page with a Jira Macro per assignee to return the info?
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.