Table Chart
A table is a chart that organizes information in rows and columns and its statistics are usually presented in a tabular format.
Example 22. Table Chart Report
Generate a report that displays number of issues logged and has been opened or 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 Fetch Filters & Verify to specify the filter value (Project). Click Run Query to get the output in tabular format.
Query Output
 |
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.