Creating a Custom Report for Dashboard

[Ken Wells]

Newbie. I have created a Custom Report Using "New vs Completed" but the resolved date is not the date I want to use as a measurement.  I want to use the Date a device entered a Status as the resolved date.  Just so you know the use case, my metric is time Order placed to time order shipped, but resolution is time order was received by the end customer and is self-reported by the customer then the ticket is closed as resolved.  Is there a different report I should use?  

[Doreen Undiri · Accepted solution]

Hi @Ken Wells 

Since you want to measure the time from Order Placed to Order Shipped , Control Chart is likely the best option. Control chart tracks cycle time or lead time based on status changes. This will allow you to see exactly how long it took for an order to move from Order Placed to Order Shipped, 

More info about control chart 👇

Control chart 

---

Dd

[Ken Wells]

Thank you. 

[Danut M _StonikByte_ · Accepted solution]

Hi @Ken Wells,

Take a look at the Cumulative Flow Diagram report. By using this report you should be able to see the number of issues (orders) in each status along the time, which I guess is what you actually want. 

See also https://confluence.atlassian.com/jirasoftwareserver/cumulative-flow-diagram-938845656.html

Danut.

[Vitalii_Bobak_SaaSJet]

Hi @Ken Wells 

Welcome to the community!
It sounds like you're dealing with a unique use case where the "resolved date" doesn't align with the status changes you're looking to measure. Fortunately, the Time Metrics Tracker | Time Between Statuses. add-on can help you customize metrics based on the specific transitions you're tracking.

For your scenario of measuring the time between "Order Placed" and "Order Shipped," you can create a custom time metric to calculate the duration between the statuses "Placed" and "Shipped." Here’s how you can do it:

1. Set Up a Custom Report:

   • Navigate to the Time Between Statuses configuration.
   • Define a new time metric by selecting the transition statuses relevant to your process, e.g., "Order Placed" → "Order Shipped."
   • Save and run the report to see the calculated durations.

2. Add to Your Dashboard:
   Once the report is set up, you can add it directly to your Jira Dashboard using the Time Metrics Dashboard gadget. This way, you can monitor the metrics at a glance and even share them with your team.

3. Visualize the Data:
   Use our export feature to visualize this data further in tools like Excel or Google Sheets for more complex analytics or custom charting.

Add-on developed by my team.

If you’re looking to dive deeper into customizing reports for specific scenarios like this, feel free to  book a live session — I’d be happy to help!

I hope you find this helpful 🚀