How get I daily status change

[Sara.B]

I have built this filter to see the tickets which are going to status analyzed in a daily basis:

status changed To Analyzed DURING (startOfDay(),endOfDay()) 

Can someone help me to find out what is wrong with the filter, because it does not show any result and yet there are tickets which status has been changed today. 

Regards,

Sara

[John Funk · Accepted solution]

Hi Sara - Welcome to the Atlassian Community!

Try putting a -1 in and see if anything shows up. 

status changed to Analyzed during (startOfDay(-1), endOfDay())

If so, then it is a timing of how your time zone is configured. 

[Sara.B]

Thanks for feedback. It is working 

[Valeriia_Havrylenko_SaaSJet]

Hi  @Sara.B  👋 

If you will need more enhanced option i suggest you to try Status Entrance Date report (Time in Status for Jira add-on) that shows the date an issue has moved to a particular status.

With this report you will get dates when the issue has entered each of the statuses on the grid as it’s shown below.



On the chart, it shows the number of tasks that have entered a status on a certain date - for example, 1 task out of 5 tasks has entered the Progress status for the first time on the 23-rd of May.

Add-on has a 30-day free trial version and free up to 10 users. 

Hope it helps 😌

[Sara.B]

@Valeriia_Havrylenko_SaaSJet thanks for the suggestion. It seems to be a practical solution but I have already found a work around. :) 

[Ignacio Aredez GenAI Expert]

If your JQL filter isn't showing the expected results, consider the following steps to troubleshoot:

Check Status Name: Ensure the "Analyzed" status is spelled exactly as it appears in Jira, as JQL is case-sensitive.

Time Zone Settings: Confirm the Jira server's time zone aligns with your intended query period, since startOfDay() and endOfDay() are based on the server's time.

Permissions: Verify you have the permissions to view all issues that might have changed status, as permission restrictions can affect filter results.

If these steps don't resolve the issue, try broadening your filter to diagnose the problem, such as checking for any status changes over a wider date range.