Scatter Report

A Scatter chart displays points that show the relationship between two sets of data. Let’s take an example of a Scatter Chart report.

Report : Generate a chart that displays a count of test cases authored in Draft and Approved for Execution day-wise for a Project (i.e. Test Case authoring daily progress - Draft Vs Approved For Execution)

SQL Query

Test Case authoring daily progress - “Draft” Vs “Approved For Execution”

SELECT
DATE_FORMAT(testcases.versionCreatedDate, '%m/%d/%Y') as "Testcase Created Date",
testcases.testCaseStatus as "Status",
COUNT(1) as "Testcase Count"
FROM testcases
WHERE testcases.projectID in (`@filter.project`)
AND testcases.testCaseStatus IN ("Draft", "Approved For Execution")
GROUP BY DATE_FORMAT(testcases.versionCreatedDate, '%m/%d/%Y'), testcases.testCaseStatus

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 Scatter Chart.

You can adjust the Columns based on the requirement to X-Axis, Y-Axis and Cross Tab.

X-axis always holds a single Test entity field with any value.
Multiple Test entity field on Y-axis creates a stacked chart; Y-axis always contain fields with numeric values.
Cross tab field will help to create a Group Stacked chart.

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.