Recurring alerts last week

Is it possible to create a NRQL statement that indicates the most repeated alerts/issue during a period of time such as a week or month, to add this information in a dashboard?

Hi, @icenter.monitoring1 :

SELECT count(*) 
FROM NrAiIncident 
WHERE event = 'open' AND type = 'Incident' 
FACET conditionName, title 
SINCE 1 week ago