nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Comments

Juan Carlos Vera

Hewllo @David Mortimer

Can you Show the code of the JQL filter?

Pasam Venkateshwarrao

Hello @David Mortimer

you can use Filter sumup gadget

David Mortimer

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

David Mortimer

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

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?

only 1.png

A A Ron 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

👍

Pasam Venkateshwarrao

Hi @David Mortimer

Please see the screenshot

Screenshot 2023-03-17 at 10.37.23 AM.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Unanswered
Groups
Help