Date: Thu, 28 Mar 2024 10:44:46 +0000 (UTC) Message-ID: <787637741.7705.1711622686682@catch-kbase-p> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7704_1120916830.1711622686681" ------=_Part_7704_1120916830.1711622686681 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The AVG function can be used on any fields supporting aggregation which = have a numeric type:
It will return the average value across all the values in the query (or = the set of values being evaluated for the current Facet or Group).
This example would return the average number of steps for each script in= a project.
AVG(Sc= riptStepCount) WHERE EntityType =3D Script
This would return the average time taken to execute scripts within a pro= ject (which have an actual duration recorded).
AVG(Ac= tualDuration) AS "Actual", AVG(EstimatedDuration) AS "Estimated" WHERE EntityType =3D Script AND ActualDuration IS NOT Empty
This would return the average number of incidents raised per test script= assignment, grouped by the type of the associated script.
GROUP = BY ScriptType { AVG(IncidentCount) AS 'Average' } AS 'Types' WHERE EntityType =3D ScriptAssignment