Get the last week JIRA tickect status

[Jyotiranjan Rout]

How can I get below details and make a dash board with it in JIRA:

1. How many/Which JIRA tickets were/are assigned to me during last week?
2. How many/Which JIRA tickets were/are taken away from me during last week?
3. How many/Which JIRA tickets were/are "work in progress" by me during last week?
4. How many/Which JIRA tickets were/are "done" by me during last week?

Please help. Thanks.

[Bill Sheboy]

Hi @Jyotiranjan Rout 

You may find all of those things using JQL and the WAS operator.  The results may then be displayed on a dashboard with one of the issue filter gadgets.  Please look here for more information about advanced JQL: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-WASWAS

To help you get started with your first use case: "How many/Which JIRA tickets were/are assigned to me during last week?"  Try a filter like:

assignee WAS currentUser() DURING (startOfWeek("-1"), endOfWeek("-1"))

You may add the project to the query if you wish to constrain this further.

Kind regards,
Bill

[Janis Plume _eazyBI_]

Hi,

You can create such repots with the eazyBI app for Jira. You are welcome to install the trial version and contact support once you need any assistance to create reports.

Kindly,

Janis, eazyBI support

[Dirk Ronsmans]

@Jyotiranjan Rout ,

Reporting on historical data is not easy out of the box, by default the metrics that Jira keeps are "what is going on now" and not "what was the state of a ticket at this point in time".

Imho, you'll have to look towards an external reporting tool that can create these metrics from the historical data.

You could for example look in to EazyBI which is able to do this.

reporting in Jira just isn't that extensive at this time (they acquired chart.io so who knows what the future will bring)

You could also write JQL statements which will mostly cover this but I'm not sure that will give you the desired outcome.

[Jyotiranjan Rout]

Hi, Is there any way to get the just the count? - if not the dashboard.