Difference between Average Age Chart gadget in Jira Server and Cloud

Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.

Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Context

Jira Server and Jira Cloud Average Age Chart gadget may show different results for the same JQL filter search considering the same tickets.

Why does this happen?

Jira cloud will only consider tickets resolved or unresolved during the month scope of its calculation, but it will not include requests created within the month for the month’s data. This approach ensures that only previously existing tickets are considered for the chart.

Jira server includes tickets created within the month, along with previously existing resolved or unresolved during the same month, in its calculation. As a result, Jira server's Average Age chart might show a different result than Jira cloud.

Example

Let us consider that we are looking at a 30 days period and our filter is the following:

Project = "Software" ORDER BY key

The actual search that the Average Age chart gadget will display in the cloud should be the following:

Project = "Software" 
AND 
( 
	resolution = "Unresolved" OR resolved >= startofmonth() 
)
AND created <= startofmonth() ORDER BY key

Now, Jira Server search will be the following:

Project = "Software" 
AND 
( 
	resolution = "Unresolved" OR resolved >= startofmonth() 
) 
ORDER BY key

Related documentation

In Cloud:

In Server:

Last modified on Nov 7, 2024

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.