KPI for the Dashboard to get Defects Closed in day
I have this KPI that works in the Dashboard to get the Defects that are closed in past 30 days. The problem with this is it lists all the Defects.
SELECT ?Defects.Status?, count(*) as value
WHERE ?Defects.Status? = 'Closed' AND ?Defects.Modified? <= ?date_month_ago? GROUP BY ?Defects.Status?
Any help on this?
Thanks in advance.