Date: Thu, 28 Mar 2024 15:53:52 +0000 (UTC) Message-ID: <1999970828.8763.1711641232718@catch-kbase-p> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8762_218029186.1711641232717" ------=_Part_8762_218029186.1711641232717 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The SUM function can be used on any fields supporting aggregation which = have a numeric type:
It will return the total value across all the values in the query (or th= e set of values being evaluated for the current Facet or Group).
The SUM function, like the AVG, MIN and MAX functions, takes a single ar= gument, which is the name of the field it should calculate over.
The follow query returns the total estimated duration of all the scripts= within 'Package X' or any of it's child packages:
SUM(Es= timatedDuration) WHERE AllPackages =3D 'Package X' AND EntityType =3D Scrip= t
This example demonstrates a query similar to that used to generate the e= xecution status graph displayed above the execution grid:
SUM(In= Progress) AS 'In Progress', SUM(Undetermined) AS 'Undetermined', SUM(Errors) AS 'Errors', SUM(Failed) AS 'Failed', SUM(NotRun) AS 'Not Run', SUM(Passed) AS 'Passed', SUM(Skipped) AS 'Skipped', SUM(Warnings) AS 'Warnings', SUM(Blocked) AS 'Blocked' WHERE EntityType IN [Script,Test]