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.