How can I get a report of days passed from issues?

Question

I already have a report that shows all the issues with Priority "Blocker", So, now I want to show all the days that have passed since the day the issues were created So I can show know that those issues need special focus for the days passed.

I looked into all the gadgets availables but I could not find one that fits the criteria.

I think the field that I will use is the "Created Date" minus current day

Regards!

Hannes Obweger - JXL for Jira · Answer

Hi @Enmanuelor Ortiz Lopez

apart from calculating this via Automation (as @kuaixp mentioned), another option would be to check the Atlassian Marketplace for apps that may help here.

E.g., your use case should be easy to do with the app that my team is working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called “smart columns” that aren’t natively available, including time since created.

This is how it looks in action:

As you can see, you can easily sort and filter by this data. You can also easily configure a different format (e.g., the number of days, or hours), and use conditional formatting to highlight issues that are above or below a certain threshold.

Since you've tagged your question for Jira Server: While Atlassian doesn't allow new apps to be listed for Jira Server in the Marketplace, JXL is still perfectly compatible; it's just that we need to generate a license for you. If the above looks interesting, just let me know and I'll happily start a free trial for you.

Hope this helps,

Best,

Hannes

kuaixp · Answer

You can create a new custom field and you can caculate the custom field by using Event-based actions.

Event_base_actions

Sometimes, i choose the simple solution, I use the JQL function 'endOfWeek()' and dashbord 'filter result' to show

the result base on weeks, so i can see the criteria base on the dashboard.Although this method does not display a specific number of days, at least I can know how many weeks ago these issues were created, so it is not perfect. But it works for me. Maybe you can try it.