Date: Fri, 29 Mar 2024 01:09:31 +0000 (UTC) Message-ID: <2005927981.10337.1711674571658@catch-kbase-p> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10336_735252740.1711674571657" ------=_Part_10336_735252740.1711674571657 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