How to add SLA goal to a filter

Question

Hello, I need advice.

I am preparing a report based on the filters that Jira SM offers. I have set 3 SLA goals for request types - Time to first response, Time to resolution and Time to neutralization. In the report, I can insert these 3 SLA goals into columns only by showing me the specific time of fulfillment (whether the SLA was fulfilled on time or breached).

I need to add a column that will show me the originally set time for the 3 mentioned goals. For example, in ticket detail is it visible "behem 24 h" (during 24 h).

Example: the consultants have 4 hours for the first response (which I can't remember) and the column in the filter shows me that they responded in 2 hours. I'm interested in how much time they have left to not exceed the SLA goal. I have many projects with many SLA goals and therefore I cannot remember which request with a given priority has which time set. Could you help me?

s_gridnevskii · Answer

Don't buy plugins from guys above, they are paid per user and your boss will not be happy.

You need some REST API, e.g.

your_instance/REST/API/latest/search?jql=type=bug

You will get issues you need in json format. Save them as json file and feed to any AI agent, e.g. Gemini. Prompt will be like

I need to create a table. First column is issue key, second is elapsed time for Time for Response field in millis, third is  elapsed time for Time for Resolution field in millis, fourth is ....

If you are afraid of agents you can use Excel to do the same, just google how to load json in Excel.

Hannes Obweger - JXL for Jira · Answer

Hi @Dominika Trnková

if you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues 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 long list of so-called smart columns that aren’t natively available, including [SLA] - Goal duration (along with many other SLA-related columns).

This is how it looks in action:

As you can see above, you can easily view, sort, and filter by your SLA's goal duration, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Of course, you can also export your data to XSLX (Excel or Google Sheets) or CSV in just two clicks.

This all just works - there's no scripting or automation whatsoever required.

Any questions just let me know,

Best,

Hannes

Olha Yevdokymova_SaaSJet · Answer

Hello @Dominika Trnková

In Jira’s native functionality, there isn't a direct way to display the originally set SLA time alongside the actual time taken within a report. However, I recommend using the SLA Time and Report add-on by SaaSJet, as it provides a solution tailored for your needs.

Solution with SLA Time and Report:

With SLA Time and Report, you can configure your reports to display both the original SLA goal and the actual fulfillment time, offering a clear comparison between your targets and actual performance. Here’s how:

* Activate SLA Custom Fields:

* In SLA Time and Report, go to the SLA Configuration Manager.
* Enable custom fields to store both the SLA goal (e.g., 4 hours for "Time to First Response") and the actual remaining time dynamically.

* Add Custom Fields to the Issue View:

* Once enabled, these fields will appear on each issue. You’ll be able to view both the SLA target (like "Time to Resolution: 24 hours") and the time left or elapsed.

* Create Detailed Reports:

* Use SLA Time and Report’s reporting tools to generate customized tables or charts. This setup will display both the originally set SLA duration and whether the SLA goal was met, breached, or paused.

2.1. Issue list selection
You can filter a list of issues for SLA Report using selections:

* by Project, Assignee, JQL, Filter, Label, Reporter, Sprint

* by SLA Config

* by Status of the SLA Timer: All started, In progress, On Pause, Met, Exceeded, Timer not started, etc.