How to create different kinds of charts using Visual Report?

The following types of Visual Reports can be generated.

 

Table Chart

For Example, QA Manager wants to create a Table Chart “Test Execution Status by Platform” that displays test cases executed against each platform and their execution statuses. The chart should be filtered by Project, Release and Cycle.

These fields are required to generate the report: Platform, Test Case Key, Test Case Summary, Execution Status and Filter on Project, Release and Cycle

  1. On the Test Entities View, select Executions module. The fields relevant to Test Executions will be listed below on the tree.

  2. Now locate the required fields one by one. You can use the search box to search the field quickly on the list.

  3. Drag the field to the chart area or just double-click on the field to add it to the chart area.

4 .Apply required Filters and Conditions to the fields as described under https://qmetrysupport.atlassian.net/wiki/spaces/QPro/pages/1337885409 .

5. Click on the Generate Table button to generate the report.

 

It gives output in tabular format. You can modify the output. You can switch to the following chart types from the table.

 

You can also add Release and Cycle as Filters along with Project. These Filters can be applied on IDs.

 

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

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

 

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


Cross Table Chart

You can modify the created table chart to generate a report with changes. For example, we want to generate a Cross Table Chart “Test Case Execution” that contains number of test cases executed for each platform against their execution status.
The fields required in the report are: Platforms, Execution Status, Test Cases Keys

In Cross Table report, users can opt to turn the Total column On/Off when required. Use the Show Total Row flag to display/hide the Total column on the report.

 

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

Column Chart

First, you need to generate a Table Chart then modify the chart by adding required columns to generate different type of charts.

You can design your custom report by selecting Chart Type, Chart Orientation, and fields on X-axis and Y-axis. Generate the chart once you are done applying your choices.

Here, X-axis and Y-axis shows cause and effect relationships on the graph.

  • X-Axis: It always holds single test entity fields with any value.

  • Y-Axis: It always contains fields with numeric values. Multiple test entity field on Y-Axis create stacked chart.

  • Cross Tab: It helps to create Group Stacked chart. A simple table only shows relationship of two variables. Whereas a Cross Tab shows the relationship between two or more variables in the table/chart.

Basic Column Chart

For example, QA Manager wants to view Count of Test Cases by Status.

The fields required in the report are: Test Case Entity, Status

Apply the Filter

 

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

Stacked Column Chart

For example, QA Manager wants to view Test Case Status grouped by Priority.

The fields required in the report are: Priority, Test Case Entity, Status

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

Bar Chart

Bar charts make comparisons easy. First, you need to generate a Table Chart then modify the chart to create a Bar chart.

For example, QA Manager wants to view Count of the Test Cases and the Test Case Priority by Test Case Status.

There are two report charts that need to be created.

  1. Count of the Test Cases (using Basic Bar Chart)

  2. Test Case Priority by Test Case Status (using Stacked Bar Chart)

The fields required in the report are: Test Case Priority, Test Case Entity, Test Case Status

  • Label: Label always holds single test entity fields with any value.

  • Data: It contains fields with numeric values. Multiple test entity fields on data create a stacked chart.

  • Cross Tab: It helps to create a group stacked chart. A simple table only shows the relationship between two variables. Whereas a Cross Tab shows the relationship between two or more variables in the table/chart.

Basic Bar Chart

 

Stacked Bar Chart

 

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

Line Chart

A line chart is a type of chart used to visualize the value of something over time. First you need to generate a Table Chart then modify the chart to create a Line chart.

For example, QA Lead wants to view the trend of issues logged during a particular period. Hence, they generate Count of Issues per Day.

The fields required in the report are: Issue Created Date, Issue Entity Key

  • X-Axis: It always holds single test entity fields with any value.

  • Y-Axis: It always contains fields with numeric values. Multiple test entity field on Y-Axis create stacked chart.

  • Cross Tab: It helps to create Group Stacked chart. A simple table only shows relationship of two variables. Whereas a Cross Tab shows the relationship between two or more variables in the table/chart.

Apply the Filter

Chart Output

 

Once you generate the chart, you can save the chart as a Gadget by clicking on the Add Gadget button.

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

Area Chart

Area Chart is useful to compare across categories and visualize the gaps between the scores. They represent each data point as shaded areas on a graph. First, you need to generate a Table Chart then modify the chart to create an Area chart.

For example, QA Manager wants to view Count Of Issues By their Created Date.

The fields required in the report are: Issue Created Date, Issue Entity Key

  • X-Axis: It always holds single test entity fields with any value.

  • Y-Axis: It always contains fields with numeric values. Multiple test entity fields on Y-Axis create stacked chart.

  • Cross Tab: It helps to create a Group Stacked chart. A simple table only shows the relationship between two variables. Whereas a Cross Tab shows the relationship between two or more variables in the table/chart.

 

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

Pie Chart

Pie Chart is used to display the composition of an attribute. First you need to generate a Table Chart then modify the chart to create a Pie chart.

For example, QA Manager wants to know the count of Issues by their priority so they generate Defects by Priority chart.

The fields required in the report are: Priority, Issue Entity Key

  • Label: Label always holds a single test entity field with any value.

  • Value: Values always holds a single test entity field with any value.

 

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

Doughnut Chart

Doughnut Chart displays the relationship of parts to a whole component. First you need to generate a Table Chart then modify the chart to create a Doughnut chart.

For example, QA Manager wants to see test case counts categorized by their execution status. So they want to generate the Test Case by Execution Status chart.

The fields required in the report are: Test Case Execution Status, Test Case Key

  • Label: Label always holds single test entity fields with any value.

  • Value: Values always holds single test entity fields with any value.

 

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

Scatter Chart

A Scatter chart displays points that show the relationship between two sets of data. First you need to generate a Table Chart then modify the chart to create a Scatter chart.

For example, QA Manager want to view Test Case authoring daily progress - Draft Vs Approved For Execution.

The fields required in the report are: Test Case Created Date, Test Case Status, Test Case Entity Key

  • X-Axis: Label always holds a single test entity field with any value.

  • Y-Axis: It always contains fields with numeric values. Multiple test entity fields on Y-Axis create a stacked chart.

  • Cross Tab: It helps to create a Group Stacked chart. A simple table only shows the relationship between two variables. Whereas a Cross Tab shows the relationship between two or more variables in the table/chart.

 

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