Date: Thu, 28 Mar 2024 23:38:44 +0000 (UTC) Message-ID: <1192005082.10099.1711669124734@catch-kbase-p> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10098_650376277.1711669124734" ------=_Part_10098_650376277.1711669124734 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Count is the simplest of aggregate functions, and will just return the c= ount of matching entities.
Count all records in Enterprise Tester
Count
Count all records in a project
Count = WHERE Project =3D 'Project X'
Count all incidents in a project with a status of "Open"
COUNT = WHERE Project =3D 'Project X' AND EntityType =3D Incident AND Status =3D Op= en
Count all incidents, grouped by their status
GROUP = BY Status { COUNT } WHERE Project =3D 'Project X' AND EntityType =3D Incide= nt