Cross Table Chart

Cross table reports are two dimensional charts that are grouped on entities at row and column level. Mostly the summary charts are generated using cross tables. Let’s take an example of a Cross Table report.

Report : Generate a report that displays the count of test cases executed for a sprint i.e cycle grouped by their execution status for a project (Name : Summary of Test Case Execution Status By Sprint).

SQL Query

Summary of Test Case Execution Status By Sprint

SELECT 
testexecutions.projectName as "Project Name", 
testexecutions.releaseName as "Release Name", 
testexecutions.cycleName as "Sprint", 
testexecutions.tcExecutionStatusName "TestCase Execution Status", 
COUNT(1) as "Execution Count"
FROM testexecutions
WHERE testexecutions.projectID in (`@Filter.project`)
GROUP BY testexecutions.releaseName, testexecutions.cycleName, testexecutions.tcExecutionStatusName

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 Cross Table report.

You can adjust the Columns based on the requirement to the Row Header, Column Header, and Values sections.

Row Header : Multiple Test Entity fields creates a grouped view in the Row section.
Column Header : Multiple Test Entity fields creates a grouped view in the Column section.
Values : Multiple/Single Value fields.

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.