Whether we can create a custom field to calculate Service Request age in Dashboard

Question

Hi Team,

Query - To create a custom field where i can calculate the age of the Service Request eg if a SR is created in on 20th July2024 and if i m looking the dashboard today , so the new custom field should provide me the details as - 20th July - today()(24th July)= 4 days (here in the example ")

the whole agenda is to get the number of days a particular SR in queue irrespective of any status

Danut M _StonikByte_ · Answer

Hi @Shabista S Ansari,

Indeed, one way would be create a field that stores the age of the issue, but this might be hard to do as it requires significant technical and administrative work in Jira.

Considering that your end goal is to have the issue age displayed on dashboard, have you consider the idea of an existing dashboard gadget that calculates and displays the age of the issues?

Our Great Gadgets app offers a WIP Aging Chart gadget that displays the issues from a filter or board by their age (vertical axis) grouped by their current status or current board column (horizontal axis) in a plot diagram like this:

On its Data tab, this gadget can displayed detailed info at the issue level, which you can easily export in CSV format:

Have a look over this article for more details:

https://community.atlassian.com/t5/App-Central/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369

If you want to give it a try, you can start with a 1-month free trial. If you need any help, feel free to contact support@stonikbyte.com.

Danut.

John Funk · Answer

Hi Shabista - Welcome to the Atlassian Community!

What I have done in the past is to create a custom number field.

Then create a scheduled trigger that runs once a day. Use a JQL that selects the issues that you want the rule to run against.

Then add an action for Edit Issue. There select the custom number field. Then in the blank field under the custom field, put this formula: