Table Chart

A table is a chart that organizes information in rows and columns and its statistics are usually presented in a tabular format. Let’s take an example of Table Chart report.

Report : Generate a report that displays no. of issues logged and has been opened/Ageing in a specific project (i.e. Defect Ageing Report).

SQL Query

Defect Ageing Report

SELECT 
issues.entityKey as "QMetry Entity Key", 
issues.jiraKey as "Jira Entity Key",
issues.summary as "Issue Summary", 
issues.issuestatus "Issue Status", 
DATEDIFF(CURDATE(), issues.createdDate) AS "Days Open" 
FROM issues
WHERE issues.projectID in (`@Filter.project`)
AND issues.issueStatus IN ("OPEN", "TO DO", "In Progress")

Click on the “Fetch Filters & Verify” button to specify the filter value (i.e. in our case you will be asked to specify the Project); clicking on “Run Query” gives output by default in tabular format.

Apply the Filter

Query Output

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.