Need help in dashboard filter - custom fields

Question

Through a query, I want to publish a report in the dashboardshow which display tickets which are pending for >3 days, as well as >1 day in a single tile.,

I tried to do it through 'Created" field (Standard), but I can only select the field one time. Is it possible to create a custom field to capture issue creation date or make a copy of 'Created field and rename.

If that is possible, we can use both the fields to show the count in two different rows.

Or is there any other way we can accomplish this requirement.

Danut M _StonikByte_ · Answer

Hi @Amitava Chattopadhyay,

You could try a JQL like this:

created >= startOfDay(-3d) AND status IN (New, Pending)

This JQL returns the issues created more than 3 days ago that are still in in New or Pending status

Another option, would be to use a plugin from Atlassian Markeplace that is capable to provide such report.

In case you want to try a plugin, our Great Gadgets app offers a WIP Aging Chart gadget that can display the issues from a filter or JQL by their current status or board column (on X axis) and their age on Y axis (time since entrance in that status, or in board column).

This gadget lets you set a threshold (the red line) to easily determine one ones that took longer. If you set that threshold to 3 days, you will easily determine the issues that took longer because they will be displayed above the threshold line, in red color.

The gadget can display a Data tab with details abut each issue, which can be easily exported in CSV, as in this example.

See more details about this gadget here: https://community.atlassian.com/forums/App-Central-articles/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369

Danut.

Tessa Tuteleers · Answer

Hi @Amitava Chattopadhyay ,

Copying a field and keeping it up to date is certainly possible, however, before we jump in the technical "how", I'm trying to understand the functional "Why|, because indeed there might be easier solutions.

* What are you trying to show on the dashboard? (goal)
* How are you doing this* How do you determine scope (filters)
* What data do you want to show (fields) 
* What format do you want (table with fields or graph,..)

Thank you for helping me understand!