KPI Calculation - Avg time for a new alert to be acknowledged over a 7 day time frame

eem4osg

I am looking to create a modern  dashboard using the KPI widget, that will display the average time over 7 days it takes for a new alert to be acknowledged, also by Entity Type.

I have the following where cause that defines the 7 day time frame and narrows down the Entity Type to Node alerts.

Where AA.TriggeredDateTime >= ADDday(-7,GetDate()) and AO.EntityType = 'Orion.Nodes'

The full Query

SELECT
COUNT(1) AS [Volume_KPI]

FROM Orion.AlertObjects AO

JOIN Orion.AlertActive AA ON AA.AlertObjectID = AO.AlertObjectID

Where AA.TriggeredDateTime >= ADDday(-7,GetDate()) and AO.EntityType = 'Orion.Nodes'

Anyone done this?

chad.every

I built something like this a while back that might serve as a base.
New Modern Dashboard - Alert Stats