Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

how to create a timestamp / dynamic report

At the moment, I am reporting on tickets that are planned for release over the course of one week. To do this I've created the query in Jira and used the Jira macro to display the tickets shortlisted dynamically.

The only problem is that because this is dynamic, the data changes. Is there a way which I can say that between dates "X" and "Y" these are the tickets that are in "Z" state?

Hopefully that makes sense?! Please let me know if you have any questions.

2 answers

Hi @Robbie Ablett ,

Maybe the last answer of this thread will help.


You may consider using eazyBI for Jira app. Using eazyBi, you may analyze historical data (issues by statuses) in past time periods, based on the changelog information: Analyze change history 

You may want to check the following report in the eazyBI demo account that shows how many issues were in different statuses at the end of each month: Issues by statuses over time

Instead of months, you may use days as well (then the number of issues in status at the end of each day will be displayed). Additionally,  add a Page filter by Fix version to include in the report only issues currently in this version. Additional filter by Time would allow you to select a smaller time period on the X-axis.

issues by status.png

Feel free to contact us at for any questions!



Ilze, eazyBI Customer Support

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence Cloud

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

43,149 views 30 134
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you