Visual Reports

There are three types of entity fields:

A search field is available to locate the required fields for each module. Each field is displayed with its corresponding field type icon.

For example, an external custom field “Release Reference” is mapped with the Requirement module in Project > Integrations tab. This mapped field is then synced in the QMetry Insight tables using the Sync fields to Reports feature. The field will be displayed as “Requirement ext_release_reference”.

The system displays records only for the latest version of the test asset. For all version data switch to Advance Query Reports.

On the right side, it is Think Space wherein you can add fields to design the report. You can drag and drop fields or select fields from Test Entities view. Drag any field to chart area to design the chart.

An error message pops up if the user tries to drop fields that are not supported in filter or chart. You can also select a field by double clicking the field on the Test Entities View.

There are three sections on Think Space:

Dynamic Filters

The dynamic filters are mostly applied on ID fields. Like Project ID, Release ID, Cycle ID. You can Select or Unselect all options on the list at a time. Select fields using drag and drop.

You can filter the search based on folder structure. The system-pre-defined folder browse option allows you to filter custom reports based on folder structure, supporting both parent and subfolder selection.

This feature is available for Requirements, Test Cases, and Test Suites, and functions only when a single project is selected.

Report Layout Design

• Fields added in this section are displayed in the report. Like Execution Status, Test Case Entity Key Project Name, Release Name etc

• Select fields using drag and drop or double clicking.

• The layout section for each chart type is different.

• You can apply multiple operations on the fileds chosen in this section. Below is the link to list of operations supported.

• Operations on Column Headers

• The latest test execution status of uncovered test cases is displayed as "null" by default.

To display a status other than "null" for such uncovered test cases, follow below steps:

1. Open the Test Case Latest Execution Status column that you added in the Column Header.

2. Hover over Math and select “Other”.

   

3. Enter the following function on the Logic tab of the pop-up that opens.

   COALESCE (<fieldname>,'<statusvalue>')

   Where, fieldname=testcases.latestExecutionStatus and status = the value that you want to print instead of "null"

   Example 26. COALESCE

   COALESCE (testcases.latestExecutionStatus,'UnCovered')

   
   
   

4. Click Apply.

You can write query and run it to generate the report. Different types of charts can be generated and then added as a report to dashboard using Add to Gadget button.

The Add Gadget pop-up opens. Enter Gadget Name and Gadget Description.

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

The system provides Chart Settings icon with each type of chart that allows you to customize the appearance of the graph. You can customize the chart colors of your choice based on the legends used in the chart along with a feature to enable or disable the legends as required.

How it works -

A. Click the cog icon on the graph. It opens the Chart Settings panel.

B. You can show or hide the legends on the graph by enabling or disabling the Visible settings.

C. You can customize the color of legends as per your requirement.

Colors of Execution Status legends appear as they set under Customization > Execution Status. You cannot change these colors from chart settings as the option remains disabled for execution status.

Go to QMetry Custom Gadget > My Gadget tab.

Refer options as follows.

1. After clicking edit above, you can edit the gadget name.

2. Option to change filters.

3. Add Column, Group by, Labels, Filters, Operations and Values.

You can apply Group By to custom fields as well as system fields of type text, which includes lookup, multi-lookup, etc. Custom fields include of QMetry custom fields and external tracker fields that are synced to QMetry Insights.

4. Choose to change the report chart.

5. Re-generate report to view the changes.

6. Click Update Gadget to save changes.

You can download the chart image in PNG, JPEG, SVG Vector and PDF formats.

Export from Create or Update Gadget

Export from Dashboard

Export in CSV from Custom Dashboard

Export in CSV from Add Gadget Screen on QMetry Custom Dashboard.

You can also export all the dashboard gadgets through the API call.