Overview

This article provides four example use cases for Custom Reporting, in which you can learn how to build reports for the following:

• Defects per Module
• Test Cases Executed per Week and Month
• Test Cases Created Within a Specific Time Frame
• Count of Test Cases by Test Case Type

For more information on Custom Reporting, please refer to this article.

Linked Defects per Module

What You Want

You want to create a Custom Report that will track how many defects are linked to each one of the Modules within the "Jira Integration Project-My Online Shop" project.

How to Build This Report

1. Within qTest Insights, select the Explore Data tab. Choose Test Runs from the drop-down menu. 
   
   
   
2. Select the +Chart icon to begin building your Custom Report.
3. Enter in the following information:
   • Label Column: Module (Level 3)
     • Note: Your Module "Level" depends on the project module hierarchy. For instance, in the "Jira Integration Project-My Online Shop" Project, there are three hierarchal levels:
       • Jira Integration- My Online Shop (1)
         • Imported From Jira (2)
           • Project Test ABC (3)
           • Ticket Booking System (3)
           • C1 (3)
           • C2 (3)
           • Team Integration (3)
           • Team Automation (3)
     • In this example, you want to view the Defects per Module Data for the Level 3 Module, so you select "Module (Level 3)."
   • Data Column: Defects (Linked); Distinct Count
     • Note: The Distinct Count option tells my Report to count all unique ID Defects linked to each Level 3 Module.
   • Bar Orientation: Horizontal
   • Relevance: Top Values; Automatic; Show: Others
     
4. To Generate the Chart, select Generate Chart.
   
   
   

This Report now shows how many Linked Jira Defects are attached to each Level 3 Module. For example, Module C-1 has five Linked Jira Defects, each belonging to Test Cases nested within this Module.

Test Cases By Type and Tester

What You Want

You want to know how many manual and automated Test Cases you have based on the identity of the individual tester.

How to Build this Report

1. Within qTest Insights, select the Explore Data tab. Choose Test Run Logs from the drop-down menu.
   
2. Select the +Crosstab icon.
3. Define the following parameters:
   
   • Header Values Column: Tester Name
   • Label Values Column: Test Case Type
   • Aggregate Values Column: Test Case ID
   • Aggregate Function: Distinct Count
   • Summary Function: leave blank; Top
     
4. Select OK to retrieve information.
   
   This table now gives you a count of manual and automated Test Cases based on the individual tester.
   Note: Your Test Case Type is based on you Type field Selection for the Test Case Object within qTest Manager.

How Many Automated Test Cases Based on the Automation Feature?

If you want to know how many Test Cases are automated based on the automation feature, then you must change either your Header Values Column or Label Values Column to "Automated."

Test Cases Created Within The Last Year per Project

What You Want

You want to be able to track how many Test Cases were created within the last year (for this example, 2018). You also want to know how many of these Test Cases belonged to certain projects.

Build a Report to Display Test Cases Created After the Start of 2018

1. Within qTest Insights, select the Explore Data tab. Choose Test Cases from the drop-down menu.
   
2. Select the Filter icon, and build a filter to only show Test Cases created after a set date (for this example, the start of 2018).
   
   Now that your filter has been applied, data will only display for Test Cases created after the beginning of 2018.
   
3. Optional: To customize both the amount of kind of columns that display in this table, select the Gear icon, and, under the Columns tab, leave checked only the columns you want to display.