Pie Chart

Pie charts are generated based on count for an entity. Let’s take an example of a Pie Chart report.

Example 29. Pie Chart

A pie chart showing number of issue logged by its status in a Project Generate a report that displays the Count of Issues per a release by priority.

SQL Query

Count of Defects By Status For a Project

SELECT 
        count(*) as "Issue Count",
        issues.issueStatus as "Issue Status"
FROM issues
WHERE issues.projectID in (`@Filter.project`)
GROUP BY issues.issueStatus

Query Output

By default the output is in Tabular format, modify the format to view it in Pie chart.

Adjust the Columns based on the requirement to X-Axis, Y-Axis and Cross Tab.

Label always holds a single Test entity field with any value.
Value always holds a single Test entity field with any value (i.e. with numeric values)

Click Add Gadget to save the report as a Gadget.

Once you save the gadget, it becomes available in Custom Gadget under My Gadget tab.

In this section:

Pie Chart

Search results