Community
Q&A
Jira
Questions
reporting on Kanban work items

reporting on Kanban work items

Is there a way to report on the work items that have been worked in a certain timeframe? Specifically, I'd like a listing of workitems that are in all statuses past To Do, on a monthly period basis, that were updated in that monthly period, listing their status.

4 answers

3 accepted

3 votes

Answer accepted

Hello @Michael Day

Welcome to the Atlassian community.

With JQL you can use

Status WAS IN (<values>) DURING (<start date>, <end date>)

Refer to

https://support.atlassian.com/jira-service-management-cloud/docs/jql-operators/

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

2 votes

Answer accepted

Hi @Michael Day

Welcome to the Atlassian Community!

Adding what @Trudy P Claspill suggested. Using the WAS ... DURING operator is a good option if you're looking for issues that were in specific statuses during a given time period.

Another option, depending on what you're trying to report, is to use the status CHANGED operator. For example:

status CHANGED FROM <statusname> TO <statusname> DURING ("2026-06-01", "2026-06-30")
status CHANGED FROM <statusname> DURING ("2026-06-01", "2026-06-30")
status CHANGED TO <statusname> ("2026-06-01", "2026-06-30")

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Answer accepted

Hi @Michael Day

Addition to previous answer, you can make date filters dynamic like below.

status CHANGED DURING (startOfMonth(-1), endOfMonth(-1)) AND statusCategory != "To Do"

For visualization, you may want to check out Multi Dimensional Pivot Table gadget. (disclosure: I work on it)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

thanks to the 3 of you who responded - it helped a lot!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Suggest an answer

Was this helpful?

Thanks!

Jira

DEPLOYMENT TYPE

CLOUD

PRODUCT PLAN

FREE

PERMISSIONS LEVEL

Product Admin

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

reporting on Kanban work items

4 answers

3 accepted

Suggest an answer

Was this helpful?

Thanks!

DEPLOYMENT TYPE

PRODUCT PLAN

PERMISSIONS LEVEL

TAGS

Community showcase

Atlassian Community Events