I want epics status report (Current status v/s last week) - as of report?

[Saad Ahmad]

On my dashboard, I'm using a 'Two-dimensional gadget' that populates all epics of my project with their current status. 

I want to see the work progress, e.g. how many epics were in To-Do last Monday v/s today.

Is there a way I can get it in real-time like below? through automation, app?

Else, if a report can be scheduled that is auto-triggered every Friday evening to an email. 

Additionally, I want another real-time view or report that could tell me how many epics moved to and from a particular status within the defined time period. 
e.g. 
from 14 apr to 21 April, 

How many Epics transitioned to 'To Do'

How many epics transitioned from 'To Do'.

-----------

I will use both stats in conjunction to analyze the work progress. 

@Ojase Emmanuval @Aron Gombas _Midori_

[Valeriia_Havrylenko_SaaSJet · Accepted solution]

Hi @Saad Ahmad 👋

Great question — tracking status movement over time at the Epic level is key for analyzing workflow progress!

While Jira’s built-in gadgets are limited in this regard, the Time In Status add-on can help you achieve exactly what you're looking for.

📊 Here’s how TIS can cover your needs:

✅ 1. Current vs. Previous Week Epic Status Comparison

Using the pivot-style report (as in the screenshot below), you can:

• View Epics grouped by Status

• Filter by TIS Periods for a custom date range

• Export to Excel or CSV

App developed by my team.
Let me know if you'd like help setting up your first report. 

[Aron Gombas _Midori_]

If you are already using Jira dashboards for reporting, you can address your second requirement with a simple Filter Results gadget.

Additionally, I want another real-time view or report that could tell me how many epics moved to and from a particular status within the defined time period. 

You can just use a JQL like:

type = Epic and status = Foobar and status changed after ... and before ...

The key here is to use the CHANGED operator. 

When your dashboard displays the reports you needed, you can periodically email it using the Better PDF Automation app! Here is the general guide, and here is the extra dashboard-specific step.

(Discl. this app is developed by our team.)

[Danut M _StonikByte_]

Hi @Saad Ahmad,

It might be possible to obtain a chart (not a table) by using the Jira's Cumulative Flow Diagram report available in your agile board, configured with a quick filter that returns only the epics. But it is pretty limited in term of grouping the data and does not seem to show the totals...

For something better, my advice is to search for an app on Atlassian Marketplace.  

if you consider the idea of using an app, our Great Gadgets app offers a Cumulative Flow Diagram gadget that can display this info in real time, in form of a stacked area chart. You can see the numbers by hovering a date in the chart. It can group the data weekly. 

All you have to do if to configure the gadget with a filter/JQL that return your epics, to configure it to display bands by issue statuses and group data weekly. 

Danut. 

[Tuncay Senturk _Snapbytes_]

Hi @Saad Ahmad 

If you are open to using a free app, you can achieve everything with the SnapMetrics - Real Time Analytic app available on the Marketplace. You can easily set Time in Status or Transition Date/User metric and view the results through your preferred filters. Trust me, you will enjoy it once you start using it and defining the metrics you wish to monitor. I am one of the team members behind this product, so feel free to ask me if you have any questions.

[Petru Simion _Simitech Ltd__]

Hi @Saad Ahmad ,

If you are open to using apps you can use one of the following apps, provided by our company.

• Issue History Dashboard for Jira 

Filter by Field Updated "Status" and the Date of Change from and to according to your needs.

Columns Value from and Value To are displaying the status from which was To Do and the status that the issue was transitioned into. Column Date of Change displays the date and time of the transitioning.

If you are interested in how much time was spent in status To Do and how many times issues were in that status (in case of being moved forth and back) you can use

• Time in Status for Jira 

Filter by Current Status "any status other than To Do" . 

For both apps, the search result is exportable in CSV format so you can do more data analysis in Excel.

Reards, 

Petru