Most Frequent Alarms

Charts and lists last 24-hours' Historical Incidents (cleared Alarms) according to those most frequently occurring, in the Adroit QuickStart configuration running on our web site

The LINQ query syntax for this chart and table is:

from incident in _context.AdrAmHistoricalIncidents
where incident.Dt > oneDayAgo
group incident by incident.Incident into g
orderby g.Count() descending
select new { Alarm = g.Key, AlarmCount = g.Count() }