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: