How to know the time it took to assign an issue in jql format

[John Benedict de Austria Abe]

Hi! Could someone tell me how to know how long it took for an issue to be assigned to the people in that specific project? Here's my jql format to see how long does it take to assign an issue but it doesn't work:
issuetype = Task AND assignee changed from EMPTY to (userid)

[Rebekka Heilmann _viadee_ · Accepted solution]

Hi @John Benedict de Austria Abe  and welcome to the Community!

The Result of JQL are always Issues, never times or other formats. To get the "Time to first Assign" you would need to set up an SLA in your Service Project.

Check out this docu if you're new to SLAs: Create service level agreements (SLAs) to manage goals | Jira Service Management Cloud | Atlassian Support

[John Benedict de Austria Abe]

Hi, I have only these options about sql:

And it doesn't work as I want

[Rebekka Heilmann _viadee_]

Hi @John Benedict de Austria Abe 

You are trying to add a new Series to a Report. First, you need to add a new SLA that measures the time. You find that in under Project settings > SLA.

After that, you can add Reports on that SLA, but that's optional as the SLA will be shown on the issues either way. The field that you are currently editing requires JQL that will limit the report on the filtered Issues. That could be all Issues from the Service project or only specific ones.

[John Benedict de Austria Abe]

Tysm for the information, now I can do the Reports that I need.

[Hannes Obweger - JXL for Jira]

Hi @John Benedict de Austria Abe

I'm glad you found an SLA-based solution! Just for future reference, for a solution that works also with non-JSM projects, you may want to have a look at 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 number of so-called smart columns that aren't natively available, including time with assignee / time unassigned.

With this, you can model a view like this in just a couple of clicks:

As you can see above, you can easily sort and filter by the time unassigned; you can  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.

Any questions just let me know,

Best,

Hannes