Ticket status during time period sorted by Assignee

Question

So, I want to have a filter for a gadget - using Two Dimensional Filter Statistics

* all tickets during time period
* status (x-Axis)
* assignee (y-Axis)

My approach:

status was in ("In Progress", Done, "To Do", Open, "On Hold", Completed, Testing) during ( start, end) AND assignee in (dev1, dev2, dev3) ORDER BY assignee ASC, status DESC

however this seems not to work :(
Issue: it shows the current status, not the status the ticket had during that time frame

HELP

Zoryana Bohutska _SaaSJet_ · Answer

Hi @Kat

For this case, you can try Issue History app. It lets you get the history of any changes, including statuses. But it hasn't a gadget for Dashboard.

If this solution is interesting for you, let me know, and I can help you get the data you need.

Regards

Kat_f30pzg · Answer

@Mariana_Pryshliak_Saasjetthanks for your response

it's not exactly what I needed - I wanted to know the status and the assignee of a ticket on a specific date
however - your suggestion is helpful in other ways for a different report of mine - thanks :)

Mariana_Pryshliak_Saasjet_qysy8m · Answer

Hello @Kat

You can try a third-party add-on - Time in Status for Jira Cloud. It generates both Time in Status and Assignee time reports.

Time in Status report shows how long an issue has been staying in each status. So you can monitor at which stage some problems or delays occur.

Assignee time report shows how long each Assignee has been assigned to each issue. It helps to get info on how long it takes to solve each of them.

Is that what you need?

Also, you can discover more info by reading use cases regarding your issue in our documentation

Best regards, Mariana