Line Chart

A line chart usually displays the information on a series of data points. Let’s take an example of a Line Chart report.

Report : Generate a report that displays the Count of Issues per a release by priority.

SQL Query

Count Of Issues Per Release By Priority

 SELECT 
 COUNT(issues.entityKey) as "Count of Issue Entity Key",
 issues.priority as "Issue Priority",
 testexecutions.releaseName as "Executions Release Name",
 testexecutions.cycleName as "Executions Cycle Name"
 FROM testexecutions  
 INNER JOIN testexecutionissue ON testexecutions.tcExecutionID = testexecutionissue.tcExecutionID   
 INNER JOIN issues ON testexecutionissue.issueID = issues.issueID  
 WHERE issues.projectID IN (`@filter.project`)
 AND issues.priority in (`@filter.issues.priority`)
 GROUP BY issues.priority, testexecutions.releaseName

Apply the Filter

Query Output

By default, it gives you output in tabular format. You can modify the output format by switching to the available chart types from the table. In our case, we will switch it to the Line Chart.

You can adjust the Columns based on the requirement to X-Axis, Y-Axis and Cross Tab.

X-axis always holds a single Test entity field with any value.
Multiple Test entity field on Y-axis creates a stacked chart; Y-axis always contain fields with numeric values.
Cross Tab field will help to create a Group Stacked chart.

Once you get your desired report, you can save the report as a Gadget by clicking on the Add Gadget button.

Once you save the gadget, it will be available in the QMetry Custom Gadget section > My Gadget tab.