Gauge Chart

Generate a chart that displays the Percentage of Automated Executions for a combination of a Project, Release, and Cycle.

SQL Query

Percentage Of Automated Executions For A Project, Release, and Cycle

SELECT
COUNT(testcases.entityKey) as "Total Testcase Execution",
COUNT(CASE WHEN testexecutions.isAutoExecuted=1 THEN 1 END) as "Automated Execution",
COUNT(CASE WHEN testexecutions.isAutoExecuted=1 THEN 1 END)/COUNT(testcases.entityKey)* 100 as "Percentage"
FROM testcases
inner join testexecutions on testcases.testcaseID = testexecutions.testcaseID 
and testcases.tcVersion = testexecutions.executedVersion
WHERE testexecutions.projectID in (`@filter.project`)
AND testexecutions.releaseID in (`@filter.release`)
AND testexecutions.cycleID in (`@filter.cycle`)

Query Output

It gives you output in tabular format. Modify the output format by switching it to the Gauge Chart.

Adjust the Columns based on the requirement to the Label and Value sections.