A line chart usually displays the information on a series of data points. Let’s take an example of a Line Chart report. The use case is, we want to generate a line chart that should display the No of the Test Cases By Status and its Priority in a Project
Report : Generate a report that displays the Count of Issues per a release by priority.
SQL Query
Test Case Count Of Issues Per Release By Status & Priority
| Code Block | ||
|---|---|---|
| ||
SELECT COUNT(1issues.entityKey) as "Test Case CountCount of Issue Entity Key", testcasesissues.priority as "Issue Priority", testexecutions.releaseName as "Executions Release Name", testcases testexecutions.testCaseStatuscycleName as "StausExecutions Cycle Name" FROM testcases testexecutions INNER JOIN testexecutionissue ON testexecutions.tcExecutionID = testexecutionissue.tcExecutionID INNER JOIN issues ON testexecutionissue.issueID = issues.issueID WHERE testcasesissues.projectID IN (`@filter.project`) AND issues.priority in (`@filter.issues.project`priority`) GROUP BY testcasesissues.priority, testcasestestexecutions.testCaseStatusreleaseName |
Apply the Filter
...
Query Output
...