Back to QMetry All Products Help Page
Area Chart
An area chart represents the change in a one or more quantities over time. It is made by plotting a series of data points over time, connecting those data points with line segments, and then filling in the area between the line and the x-axis with color or shading. Let’s take an example of an Area Chart report.
Report : Generate an area chart that displays the Count of the test cases executed per day along with the execution status (i.e. Test Case Execution Per Day)
SQL Query
Test Case Execution Per Day
SELECT
DATE_FORMAT(testexecutions.tcExecutionEndTime, "%m/%d/%Y") "Execution Date",
testexecutions.tcExecutionStatusName "Execution Staus",
COUNT(1) as "Test Case Count"
FROM testexecutions
WHERE testexecutions.projectID in (`@filter.project`)
AND testexecutions.tcExecutionStatusName NOT IN ("Not Run", "Not Applicable")
GROUP BY DATE_FORMAT(testexecutions.tcExecutionEndTime, '%m/%d/%Y'), testexecutions.tcExecutionStatusName
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 Area 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.
Back to QMetry All Products Help Page